select privilege from dba_sys_privs where grantee='&USERNAME'
union
select privilege from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee='&USERNAME' );
查看用户所拥有的所有权限的sql语句
最新推荐文章于 2023-10-23 20:55:56 发布
select privilege from dba_sys_privs where grantee='&USERNAME'
union
select privilege from dba_sys_privs where grantee in
(select granted_role from dba_role_privs where grantee='&USERNAME' );