Oracle数据库访问控制权限的分类

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

分享文章：Oracle数据库访问控制权限的分类
文章URL：http://www.csdahua.cn/qtweb/news37/130837.html

网站建设、网络推广公司-快上网，是专注品牌与效果的网站制作，网络营销seo公司；服务项目有等

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源：快上网

成都快上网为您推荐相关内容