–查看所有用户权限
SELECT * FROM dba_users;
SELECT * FROM all_users;
SELECT * FROM user_users;
–查看用户系统权限
SELECT * FROM dba_sys_privs;
SELECT * FROM user_sys_privs;
–查看用户对象权限
SELECT * FROM dba_tab_privs;
SELECT * FROM all_tab_privs;
SELECT * FROM user_tab_privs;
–查看所有角色
SELECT * FROM dba_roles;
–查看用户所拥有的角色
SELECT * FROM dba_role_privs;
SELECT * FROM user_role_privs;
–查看当前用户缺省表空间
SELECT username,default_tablespace FROM user_users;
–查看resource具体那些权限
SELECT * FROM dba_sys_privs WHERE grantee=’RESOURCE’;