似乎來自session_privs和user_sys_privs的簡單選擇提供了所有當前權限，但我無法區分其中哪些是從角色繼承的，哪些是直接授予的。
有沒有辦法只列出直接授予的特權？
uj5u.com熱心網友回復：
如果你查詢dictionary，這里有一些有趣的結果：
SQL> select * from dictionary where lower(table_name) like '%user%privs%' order by table_name;
TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------
USER_AQ_AGENT_PRIVS
USER_COL_PRIVS Grants on columns for which the user is the owner, grantor or grantee
USER_COL_PRIVS_MADE All grants on columns of objects owned by the user
USER_COL_PRIVS_RECD Grants on columns for which the user is the grantee
USER_ROLE_PRIVS Roles granted to current user
USER_RSRC_CONSUMER_GROUP_PRIVS Switch privileges for consumer groups for the user
USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
USER_SYS_PRIVS System privileges granted to current user
USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE All grants on objects owned by the user
USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee
11 rows selected.
SQL>
您可能感興趣的視圖 - 因為它們顯示直接授予您的權限 - 是
- user_sys_privs
- user_tab_privs
- user_role_privs
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/472534.html