DBA FUS‎ > ‎

Users or roles granted ALL PRIVILEGES or too many privileges

posted Sep 13, 2010, 6:24 AM by Sachchida Ojha
-- 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;

Comments