-- 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.
Showing posts with label users or roles granted ALL PRIVILEGES or too many privileges. Show all posts
Showing posts with label users or roles granted ALL PRIVILEGES or too many privileges. Show all posts
Wednesday, January 13, 2010
Subscribe to:
Posts (Atom)