DBA FUS‎ > ‎

Developer Privileges on Shared Systems

posted Sep 13, 2010, 6:05 AM by Sachchida Ojha
SELECT GRANTEE||': '||PRIVILEGE FROM DBA_SYS_PRIVS WHERE
    (PRIVILEGE LIKE 'CREATE%' OR PRIVILEGE LIKE 'ALTER%'OR PRIVILEGE LIKE 'DROP%')
    AND PRIVILEGE<>'CREATE SESSION'
    AND GRANTEE NOT IN
            ('SYS','SYSTEM','ANONYMOUS','AQ_ADMINISTRATOR_ROLE','MTSSYS',
 'CONNECT','CTXSYS','DBA','IMP_FULL_DATABASE','MDSYS','ODM',
 'ODM_MTR','OEM_MONITOR','OLAPSYS','OLAP_DBA','ORDPLUGINS','ORDSYS',
  'RECOVERY_CATALOG_OWNER','RESOURCE','SYS','WKPROXY','WKSYS',
  'WKUSER','WMSYS','XDB','TIMESERIES_DEVELOPER','TIMESERIES_DBA',
  'LBACSYS','DBSNMP','OLAP_USER') order by grantee;

Comments