Oracle Privileges and Roles

Oracle Privileges

Oracle包括两大类权限，一种是系统权限，另外一种是对象权限。

System Privileges

• Create session
• Create table
• Create view
• Create procedure
• Sysdba
• Sysoper

Object Privileges  Privileges can be assigned to any of the following types of database objects:

• Tables: all, alter, debug, delete, flashback, insert, on commit refresh, query rewrite, references, select, update
• Views: debug, delete, insert, flashback, references, select, under, update
• Sequence: alter, select
• Packages, Procedures, Functions: debug, execute
• Materialized Views: delete, flashback, insert, select, update
• Directories: read, write
• Libraries: execute
• User Defined Types: debug, execute, under
• Operators: execute
• Indextypes: execute

Privileges Tables/Views

System Privileges： DBA_SYS_PRIVS

Object Privileges: DBA_TAB_PRIVS
Data Dictionary Objects Related To Object Privileges