oracle所有的sys权限

注 这里不是role权限. sys权限和role权限会取最大集.
执行sql:

select privilege from dba_sys_privs  group by privilege;

共有200多个,如下:

MERGE ANY VIEW
DROP ANY PROCEDURE
ALTER ANY CLUSTER
UNLIMITED TABLESPACE
CREATE JOB
CREATE TABLE
SELECT ANY TRANSACTION
DROP ANY RULE SET
ALTER ANY RULE SET
DROP ANY DIRECTORY
ALTER ANY TABLE
AUDIT SYSTEM
FLASHBACK ARCHIVE ADMINISTER
CREATE ANY CUBE DIMENSION
CREATE MATERIALIZED VIEW
DROP ANY CLUSTER
EXECUTE ANY LIBRARY
CREATE ANY LIBRARY
DROP ANY EDITION
GRANT ANY OBJECT PRIVILEGE
ADMINISTER ANY SQL TUNING SET
DROP ANY DIMENSION
DROP PROFILE
UPDATE ANY CUBE BUILD PROCESS
DROP PUBLIC DATABASE LINK
ALTER ANY CUBE DIMENSION
DROP ANY MATERIALIZED VIEW
ALTER ANY OPERATOR
CREATE CUBE DIMENSION
IMPORT FULL DATABASE
CREATE LIBRARY
DROP TABLESPACE
ALTER PROFILE
ALTER SESSION
UPDATE ANY CUBE DIMENSION
EXECUTE ASSEMBLY
UNDER ANY TABLE
ALTER ANY TYPE
ALTER ANY ASSEMBLY
CREATE ANY RULE
DROP ROLLBACK SEGMENT
ADMINISTER SQL TUNING SET
CREATE ANY CUBE
ALTER ANY RULE
RESUMABLE
ON COMMIT REFRESH
BECOME USER
EXECUTE ANY CLASS
CREATE ANY CUBE BUILD PROCESS
SELECT ANY CUBE
EXECUTE ANY PROCEDURE
CREATE ANY CLUSTER
GLOBAL QUERY REWRITE
ALTER ANY MATERIALIZED VIEW
CREATE ANY ASSEMBLY
CREATE ASSEMBLY
DROP ANY OPERATOR
FORCE TRANSACTION
ALTER ANY ROLE
ALTER ANY PROCEDURE
CREATE VIEW
ANALYZE ANY
CREATE CUBE BUILD PROCESS
CREATE OPERATOR
DROP ANY CUBE DIMENSION
CREATE RULE SET
CREATE ANY EVALUATION CONTEXT
CREATE ANY OPERATOR
CREATE ANY SEQUENCE
COMMENT ANY TABLE
EXECUTE ANY RULE
DROP ANY ASSEMBLY
ALTER ROLLBACK SEGMENT
ALTER ANY SQL PROFILE
CREATE ROLE
EXECUTE ANY EVALUATION CONTEXT
ALTER ANY TRIGGER
ADMINISTER SQL MANAGEMENT OBJECT
AUDIT ANY
DROP ANY CUBE BUILD PROCESS
DROP ANY CUBE
ALTER USER
CREATE SYNONYM
CREATE ANY MINING MODEL
CREATE ANY RULE SET
CREATE TYPE
ANALYZE ANY DICTIONARY
EXECUTE ANY PROGRAM
SELECT ANY CUBE DIMENSION
DELETE ANY CUBE DIMENSION
DROP ANY SQL PROFILE
DROP ANY SYNONYM
CREATE ANY SQL PROFILE
ALTER ANY SEQUENCE
DROP ANY INDEX
COMMENT ANY MINING MODEL
MANAGE TABLESPACE
CREATE ANY JOB
UPDATE ANY CUBE
QUERY REWRITE
ALTER ANY INDEX
UNDER ANY VIEW
UPDATE ANY TABLE
CREATE CLUSTER
DEBUG CONNECT SESSION
EXECUTE ANY INDEXTYPE
MANAGE ANY QUEUE
EXECUTE ANY OPERATOR
DELETE ANY TABLE
FLASHBACK ANY TABLE
ALTER ANY INDEXTYPE
DROP ANY MEASURE FOLDER
CREATE ANY OUTLINE
BACKUP ANY TABLE
UNDER ANY TYPE
DROP ANY SEQUENCE
CREATE ANY TABLE
DROP ANY TRIGGER
INSERT ANY TABLE
CREATE ANY MEASURE FOLDER
ALTER ANY CUBE
DROP ANY MINING MODEL
DROP ANY TABLE
CHANGE NOTIFICATION
DELETE ANY MEASURE FOLDER
INSERT ANY CUBE DIMENSION
ADVISOR
ADMINISTER RESOURCE MANAGER
FORCE ANY TRANSACTION
CREATE ANY SYNONYM
CREATE MINING MODEL
CREATE ANY DIMENSION
EXECUTE ANY TYPE
CREATE TABLESPACE
SELECT ANY SEQUENCE
CREATE DIMENSION
CREATE ANY PROCEDURE
CREATE ROLLBACK SEGMENT
ALTER SYSTEM
READ ANY FILE GROUP
LOCK ANY TABLE
CREATE ANY DIRECTORY
ALTER ANY MINING MODEL
ALTER ANY LIBRARY
DROP ANY TYPE
GRANT ANY PRIVILEGE
CREATE PROFILE
DROP ANY LIBRARY
MANAGE ANY FILE GROUP
DROP ANY RULE
DROP ANY INDEXTYPE
ALTER RESOURCE COST
CREATE RULE
ENQUEUE ANY QUEUE
CREATE ANY TRIGGER
CREATE ANY INDEX
SELECT ANY TABLE
CREATE USER
CREATE SESSION
INSERT ANY MEASURE FOLDER
CREATE TRIGGER
CREATE ANY EDITION
EXECUTE ANY RULE SET
CREATE MEASURE FOLDER
MANAGE FILE GROUP
DROP ANY EVALUATION CONTEXT
CREATE ANY TYPE
RESTRICTED SESSION
CREATE PUBLIC SYNONYM
MANAGE SCHEDULER
DROP ANY CONTEXT
ALTER DATABASE
CREATE EVALUATION CONTEXT
EXECUTE ANY ASSEMBLY
SELECT ANY MINING MODEL
ALTER ANY EDITION
DEQUEUE ANY QUEUE
CREATE INDEXTYPE
DROP USER
ALTER ANY EVALUATION CONTEXT
ALTER TABLESPACE
GRANT ANY ROLE
CREATE PROCEDURE
CREATE SEQUENCE
SELECT ANY DICTIONARY
CREATE EXTERNAL JOB
CREATE DATABASE LINK
DROP ANY OUTLINE
CREATE PUBLIC DATABASE LINK
DROP ANY VIEW
ALTER ANY OUTLINE
CREATE ANY CONTEXT
DEBUG ANY PROCEDURE
ADMINISTER DATABASE TRIGGER
DROP PUBLIC SYNONYM
CREATE CUBE
CREATE ANY INDEXTYPE
DROP ANY ROLE
CREATE ANY VIEW
ALTER ANY DIMENSION
CREATE ANY MATERIALIZED VIEW
EXPORT FULL DATABASE
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值