Google+ Followers

Pages

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'
                       )


No comments:

Post a Comment