新聞中心
Oracle數(shù)據(jù)庫(kù)訪問(wèn)控制權(quán)限主要分為以下幾類(lèi):

網(wǎng)站建設(shè)哪家好,找成都創(chuàng)新互聯(lián)公司!專(zhuān)注于網(wǎng)頁(yè)設(shè)計(jì)、網(wǎng)站建設(shè)、微信開(kāi)發(fā)、小程序設(shè)計(jì)、集團(tuán)企業(yè)網(wǎng)站建設(shè)等服務(wù)項(xiàng)目。為回饋新老客戶創(chuàng)新互聯(lián)還提供了鎮(zhèn)康免費(fèi)建站歡迎大家使用!
1、系統(tǒng)權(quán)限(System Privileges)
系統(tǒng)權(quán)限是針對(duì)整個(gè)數(shù)據(jù)庫(kù)實(shí)例的,它們控制用戶對(duì)數(shù)據(jù)庫(kù)系統(tǒng)的訪問(wèn),系統(tǒng)權(quán)限主要包括以下幾種:
| 系統(tǒng)權(quán)限 | 描述 |
| CREATE SESSION | 創(chuàng)建會(huì)話 |
| CREATE TABLESPACE | 創(chuàng)建表空間 |
| CREATE USER | 創(chuàng)建用戶 |
| CREATE PROCEDURE | 創(chuàng)建存儲(chǔ)過(guò)程 |
| CREATE TRIGGER | 創(chuàng)建觸發(fā)器 |
| CREATE SEQUENCE | 創(chuàng)建序列 |
| ALTER SESSION | 修改會(huì)話設(shè)置 |
| ALTER USER | 修改用戶信息 |
| ALTER SYSTEM | 修改系統(tǒng)參數(shù) |
| AUDIT SYSTEM | 審計(jì)系統(tǒng)事件 |
| FLASHBACK ARCHIVE ADMIN | 管理閃回歸檔日志 |
| LOCK TABLESPACE | 鎖定表空間 |
| UNDER ANY JOB | 在任何作業(yè)下執(zhí)行操作 |
| UNDER ANY SQL | 在任何SQL語(yǔ)句下執(zhí)行操作 |
| UNDER ANY OSUSER | 在任何操作系統(tǒng)用戶下執(zhí)行操作 |
| UNDER ANY DBAUSER | 在任何DBA用戶下執(zhí)行操作 |
| UNDER ANY SCHEMA | 在任何模式下執(zhí)行操作 |
| UNDER ANY DDL | 在任何數(shù)據(jù)定義語(yǔ)言下執(zhí)行操作 |
| UNDER ANY DML | 在任何數(shù)據(jù)操縱語(yǔ)言下執(zhí)行操作 |
| UNDER ANY DCL | 在任何數(shù)據(jù)控制語(yǔ)言下執(zhí)行操作 |
| UNDER ANY DDL OR DML OR DCL | 在任何數(shù)據(jù)定義、操縱或控制語(yǔ)言下執(zhí)行操作 |
2、對(duì)象權(quán)限(Object Privileges)
對(duì)象權(quán)限是針對(duì)數(shù)據(jù)庫(kù)中特定對(duì)象的,如表、視圖、索引等,對(duì)象權(quán)限主要包括以下幾種:
| 對(duì)象權(quán)限 | 描述 |
| ALL PRIVILEGES ON SCHEMA | 對(duì)模式的所有對(duì)象擁有所有權(quán)限 |
| ALL PRIVILEGES ON ALL SCHEMAS IN THE PACKAGE | 對(duì)包中的所有模式的所有對(duì)象擁有所有權(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
新聞名稱(chēng):Oracle數(shù)據(jù)庫(kù)訪問(wèn)控制權(quán)限的分類(lèi)
分享地址:http://www.dlmjj.cn/article/dpchphj.html


咨詢(xún)
建站咨詢(xún)
