Oracle数据库访问控制权限主要分为以下几类：
1、系统权限（System Privileges）
系统权限是针对整个数据库实例的，它们控制用户对数据库系统的访问，系统权限主要包括以下几种：
| 系统权限 | 描述 |
| CREATE SESSION | 创建会话 |
| CREATE TABLESPACE | 创建表空间 |
| CREATE USER | 创建用户 |
| CREATE PROCEDURE | 创建存储过程 |
| CREATE TRIGGER | 创建触发器 |
| CREATE SEQUENCE | 创建序列 |
| ALTER SESSION | 修改会话设置 |
| ALTER USER | 修改用户信息 |
| ALTER SYSTEM | 修改系统参数 |
| AUDIT SYSTEM | 审计系统事件 |
| FLASHBACK ARCHIVE ADMIN | 管理闪回归档日志 |
| LOCK TABLESPACE | 锁定表空间 |
| UNDER ANY JOB | 在任何作业下执行操作 |
| UNDER ANY SQL | 在任何SQL语句下执行操作 |
| UNDER ANY OSUSER | 在任何操作系统用户下执行操作 |
| UNDER ANY DBAUSER | 在任何DBA用户下执行操作 |
| UNDER ANY SCHEMA | 在任何模式下执行操作 |
| UNDER ANY DDL | 在任何数据定义语言下执行操作 |
| UNDER ANY DML | 在任何数据操纵语言下执行操作 |
| UNDER ANY DCL | 在任何数据控制语言下执行操作 |
| UNDER ANY DDL OR DML OR DCL | 在任何数据定义、操纵或控制语言下执行操作 |
2、对象权限（Object Privileges）
对象权限是针对数据库中特定对象的，如表、视图、索引等，对象权限主要包括以下几种：
| 对象权限 | 描述 |
| ALL PRIVILEGES ON SCHEMA | 对模式的所有对象拥有所有权限 |
| ALL PRIVILEGES ON ALL SCHEMAS IN THE PACKAGE | 对包中的所有模式的所有对象拥有所有权限 |
| ALL PRIVILEGES ON ALL SCHEMAS IN THE PACKAGE AND ALL OF THEIR OWNED PROCEDURES AND FUNCTIONS IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR FUNCTION IN THE PACKAGE AND ALL OF THEIR OWNED IMPLICITLY RESOLVED GRANTED BY ANOTHER PACKAGE PROCEDURE OR
原创文章，作者：未希，如若转载，请注明出处：https://www.kdun.com/ask/503276.html
微信扫一扫