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语句
最新推荐文章于 2024-04-18 15:42:41 发布
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' );