select grantee,owner table_owner,table_name,privilege from dba_tab_privs where grantee<> owner
and grantee not in ('SYS','PUBLIC','SYSTEM','WMSYS') and owner='用户名'
order by 1,3,4
Oracle导出用户授权
最新推荐文章于 2023-10-14 08:49:12 发布
select grantee,owner table_owner,table_name,privilege from dba_tab_privs where grantee<> owner
and grantee not in ('SYS','PUBLIC','SYSTEM','WMSYS') and owner='用户名'
order by 1,3,4