oracle查看指定的用户权限
系统权限:
SQL> SELECT * FROM SYSTEM_PRIVILEGE_MAP ORDER BY NAME;
指定的用户:
SQL> select * from dba_sys_privs where grantee='QUEST';
SQL> SELECT * FROM SYSTEM_PRIVILEGE_MAP ORDER BY NAME;
指定的用户:
SQL> select * from dba_sys_privs where grantee='QUEST';