-- 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;
Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment