-- Check for all privs:
(select count(*) from system_privilege_map) intersect
(select count(*) from dba_sys_privs group by grantee);
-- Check for number of privs in case too many:
select count(*) from system_privilege_map;
-- Check how many privileges each account has:
select count(*),grantee
from dba_sys_privs
group by grantee;
No comments:
Post a Comment