查询用户privilege

Listing Privilege and Role Information

To list the grants made for objects, a user can query the following data dictionary views:

• ALL_COL_PRIVS, USER_COL_PRIVS, DBA_COL_PRIVS

• ALL_COL_PRIVS_MADE, USER_COL_PRIVS_MADE

• ALL_COL_PRIVS_RECD, USER_COL_PRIVS_RECD

• ALL_TAB_PRIVS, USER_TAB_PRIVS, DBA_TAB_PRIVS

• ALL_TAB_PRIVS_MADE, USER_TAB_PRIVS_MADE

• ALL_TAB_PRIVS_RECD, USER_TAB_PRIVS_RECD

• DBA_ROLES

• USER_ROLE_PRIVS, DBA_ROLE_PRIVS

• USER_SYS_PRIVS, DBA_SYS_PRIVS

• COLUMN_PRIVILEGES

• ROLE_ROLE_PRIVS, ROLE_SYS_PRIVS, ROLE_TAB_PRIVS

• SESSION_PRIVS, SESSION_ROLES

See Also: See the for a detailed description of these data dictionary views.

 

Listing All System Privilege Grants

The following query indicates all system privilege grants made to roles and users:

SELECT * FROM sys.dba_sys_privs;

GRANTEE            PRIVILEGE                         ADM
--------------     ---------------------------------  ---
SECURITY_ADMIN     ALTER PROFILE                     YES
SECURITY_ADMIN     ALTER USER                        YES
SECURITY_ADMIN     AUDIT ANY                         YES
SECURITY_ADMIN     AUDIT SYSTEM                      YES
SECURITY_ADMIN     BECOME USER                       YES
SECURITY_ADMIN     CREATE PROFILE                    YES
SECURITY_ADMIN     CREATE ROLE                       YES
SECURITY_ADMIN     CREATE USER                       YES
SECURITY_ADMIN     DROP ANY ROLE                     YES
SECURITY_ADMIN     DROP PROFILE                      YES
SECURITY_ADMIN     DROP USER                         YES
SECURITY_ADMIN     GRANT ANY ROLE                    YES
SWILLIAMS          CREATE SESSION                     NO
JWARD              CREATE SESSION                     NO