2024年3月3日发(作者：)

系统权限列表

在这里我们列出所有的权限，并将它们分类。这里只列出权限名，有关权限的详细说明请参考oracle官方参考手册。

1.数据库管理员系统权限（数据库实体管理部分）

ADUIT ANY

CREATE ANY CLUSTER

ALTER ANY CLUSTER

DROP ANY CLUSTER

CREATE ANY INDEX

ALTER ANY INDEX

DROP ANY INDEX

GRANT ANY PRIVILEGE

CREATE ANY PROCEDURE

ALTER ANY PROCEDURE

DROP ANY PROCEDURE

EXECUTE ANY PROCEDURE

ALTER ANY ROLE

DROP ANY ROLE

GRANT ANY ROLE

CREATE ANY SEQUENCE

ALTER ANY SEQUENCE

DROP ANY SEQUENCE

SELECT ANY SEQUENCE

CREATE ANY SNAPSHOT

ALTER ANY SNAPSHOT

DROP ANY SNAPSHOT

CREATE ANY SYSNONYM

DROP ANY SYSNONYM

CREATE ANY TABLE

ALTER ANY TABLE

DROP ANY TABLE

LOCK ANY TABLE

COMMENT ANY TABLE

SELECT ANY TABLE

INSERT ANY TABLE

UPDATE ANY TABLE

DELETE ANY TABLE

CREATE ANY TRIGGER

ALTER ANY TRIGGER

DROP ANY TRIGGER

CREATE ANY VIEW

DROP ANY VIEW

CREATE ANY TYPE

DROP ANY TYPE

CREATE ANY LIBRARY

DROP ANY LIBRARY

2.数据库管理系统权限(数据库维护部分)

ALTER DATABASE

CREATE PROFILE

ALTER PROFILE

DROP PROFILE

ALTER RESOURCE COST

CREATE PUBLIC DATABASE LINK

DROP PUBLIC DATABASE LINK

CREATE ROLE

CREATE ROLLBACK SEGMENT

ALTER ROLLBACK SEGMENT

DROP ROLLBACK SEGMENT

ALTER SYSTEM

CREATE TABLESPACE

ALTER TABLESPACE

MANAGE TABLESPACE

ALTER USER

DROP USER

CREATE SESSION

CREATE PUBLIC SYNONYM

DROP PUBLIC SYNONYM

UNLIMITED TABLESPACE

CREATE ROLE

DROP ROLE

3.数据库开发用户系统权限表

CREATE CLUSTER

DROP CLUSTER

CREATE PROCEDURE

DROP PROCEDURE

CREATE DATABASE LINK

CREATE SYSNONYM

DROP SYNONYM

CREATE SEQUENCE

CREATE SNAPSHOTP

CREATE TABLE

CREATE VIEW

UNLIMITED TABLESPACE

CREATE TYPE

CREATE LIBRARY

GRANT 实体权限名|ALL TO 用户|角色|PUBLIC

其中，ALL表示实体的所有实体权限。