Oracle 用户权限查看

grantee 就是被授权者 角色 select granted_role from dba_role_privs where grantee='username'; 授权 select privilege from dba_sys_privs where grantee='username'; 对象 select * from dba_tab_privs where grantee='username' order by table_name; 其他： select table_name from dba_tables where owner='username'; select view_name from dba_views where owner='username'; select TABLE_NAME,TABLE_OWNER from dba_synonyms where owner='username' order by table_name;