查看用户当前所赋予的权限：
SQL> select * from dba_sys_privs where grantee ='PROFILE'; GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- PROFILE INSERT ANY TABLE NO PROFILE UNLIMITED TABLESPACE NO PROFILE DROP ANY SEQUENCE NO PROFILE UPDATE ANY TABLE NO PROFILE DROP ANY TABLE NO PROFILE ALTER ANY SEQUENCE NO PROFILE SELECT ANY TABLE NO PROFILE DROP TABLESPACE NO PROFILE CREATE TABLESPACE NO PROFILE GRANT ANY PRIVILEGE NO PROFILE SELECT ANY SEQUENCE NO GRANTEE PRIVILEGE ADM ------------------------------ ---------------------------------------- --- PROFILE CREATE ANY INDEX NO PROFILE DELETE ANY TABLE NO PROFILE CREATE ANY TABLE NO PROFILE CREATE TABLE NO PROFILE SELECT ANY DICTIONARY NO PROFILE CREATE ANY SEQUENCE NO PROFILE CREATE SEQUENCE NO PROFILE ALTER ANY TABLE NO PROFILE DROP USER NO PROFILE CREATE USER NO
查看用户当前所赋予的角色：
conn profile/password; SQL> select * from USER_ROLE_PRIVS; USERNAME GRANTED_ROLE ADM DEF OS_ ------------------------------ ------------------------------ --- --- --- PROFILE CONNECT NO YES NO conn / as sysdba SQL> select * from dba_role_privs where grantee ='PROFILE'; GRANTEE GRANTED_ROLE ADM DEF ------------------------------ ------------------------------ --- --- PROFILE RESOURCE NO YES PROFILE CONNECT NO YES