Pages

Showing posts with label privileges query. Show all posts
Showing posts with label privileges query. Show all posts

Friday, August 31, 2012

Find Power Privileges given to users



To check which Powerful privileges are granted to users perform following query.




select grantee, privilege, admin_option
from   sys.dba_sys_privs
where  (privilege like '% ANY %'
  or   privilege in ('BECOME USER', 'UNLIMITED TABLESPACE')
  or   admin_option = 'YES')
 and   grantee not in ('SYS', 'SYSTEM', 'OUTLN', 'AQ_ADMINISTRATOR_ROLE',
                       'DBA', 'EXP_FULL_DATABASE', 'IMP_FULL_DATABASE',
                       'OEM_MONITOR', 'CTXSYS', 'DBSNMP', 'IFSSYS',
                       'MDSYS', 'ORDPLUGINS', 'ORDSYS'
                       )