Oracle Role and Privileges

介紹一些跟角色(role)還有oracle系統權限(privileges)相關的view:

VIEW	Description
DBA_ROLES	All Roles which exist in the database
DBA_ROLE_PRIVS	Roles granted to users and roles
ROLE_ROLE_PRIVS	Roles which are granted to roles
ROLE_SYS_PRIVS	System privileges granted to roles
ROLE_TAB_PRIVS	Table privileges granted to roles

個人覺得最實用的是ROLE_SYS_PRIVS，在授予使用者角色時，用這個表可以看出ROLE包了哪些system privileges。

另外加贈兩個不錯的view: DBA_TAB_COMMENTS, DBA_COL_COMMENTS分別可以看表格或表格欄位的說明~