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.

Wednesday, January 13, 2010

users or roles granted ALL PRIVILEGES or too many privileges

-- 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: