Oracle數(shù)據(jù)庫訪問控制權(quán)限主要分為以下幾類：

網(wǎng)站建設(shè)哪家好，找成都創(chuàng)新互聯(lián)公司！專注于網(wǎng)頁設(shè)計、網(wǎng)站建設(shè)、微信開發(fā)、小程序設(shè)計、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了鎮(zhèn)康免費建站歡迎大家使用！

1、系統(tǒng)權(quán)限（System Privileges）

系統(tǒng)權(quán)限是針對整個數(shù)據(jù)庫實例的，它們控制用戶對數(shù)據(jù)庫系統(tǒng)的訪問，系統(tǒng)權(quán)限主要包括以下幾種：

系統(tǒng)權(quán)限	描述
CREATE SESSION	創(chuàng)建會話
CREATE TABLESPACE	創(chuàng)建表空間
CREATE USER	創(chuàng)建用戶
CREATE PROCEDURE	創(chuàng)建存儲過程
CREATE TRIGGER	創(chuàng)建觸發(fā)器
CREATE SEQUENCE	創(chuàng)建序列
ALTER SESSION	修改會話設(shè)置
ALTER USER	修改用戶信息
ALTER SYSTEM	修改系統(tǒng)參數(shù)
AUDIT SYSTEM	審計系統(tǒng)事件
FLASHBACK ARCHIVE ADMIN	管理閃回歸檔日志
LOCK TABLESPACE	鎖定表空間
UNDER ANY JOB	在任何作業(yè)下執(zhí)行操作
UNDER ANY SQL	在任何SQL語句下執(zhí)行操作
UNDER ANY OSUSER	在任何操作系統(tǒng)用戶下執(zhí)行操作
UNDER ANY DBAUSER	在任何DBA用戶下執(zhí)行操作
UNDER ANY SCHEMA	在任何模式下執(zhí)行操作
UNDER ANY DDL	在任何數(shù)據(jù)定義語言下執(zhí)行操作
UNDER ANY DML	在任何數(shù)據(jù)操縱語言下執(zhí)行操作
UNDER ANY DCL	在任何數(shù)據(jù)控制語言下執(zhí)行操作
UNDER ANY DDL OR DML OR DCL	在任何數(shù)據(jù)定義、操縱或控制語言下執(zhí)行操作

2、對象權(quán)限（Object Privileges）

對象權(quán)限是針對數(shù)據(jù)庫中特定對象的，如表、視圖、索引等，對象權(quán)限主要包括以下幾種：

對象權(quán)限	描述
ALL PRIVILEGES ON SCHEMA	對模式的所有對象擁有所有權(quán)限
ALL PRIVILEGES ON ALL SCHEMAS IN THE PACKAGE	對包中的所有模式的所有對象擁有所有權(quán)限

| 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

當(dāng)前標(biāo)題：Oracle數(shù)據(jù)庫訪問控制權(quán)限的分類
URL分享：http://uogjgqi.cn/article/dpchphj.html