Snippet Name: Find users with deadly privileges Description: Finds database users with deadly system privileges assigned to them. Also see:» Add PSOUG Search to SQL Developer » Converting Rows to Columns » Database Links: CURRENT_USER » Instant Test Database with DCBA » Show info on current context » Lookup Oracle error messages » Display and release DBMS_LOCK locks » Display locks and latches » Show rollback segment stats » Show active transactions » List supported INIT.ORA parameters » Display database SGA statistics » Measure the Buffer Cache Hit Ratio » List security related profile informat... » Audit User Logins (User Login Trigger) » Block TOAD and other tools » Kill Session » Extents » DBA Users » DBA Tablespaces » DBA triggers » DBA Sessions » DBA Roles » DBA Objects » DBA Links » DBA Jobs » Job Queue » DBA Free Space » Data Files » DBA Extents Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
Description: Finds database users with deadly system privileges assigned to them.
Also see:» Add PSOUG Search to SQL Developer » Converting Rows to Columns » Database Links: CURRENT_USER » Instant Test Database with DCBA » Show info on current context » Lookup Oracle error messages » Display and release DBMS_LOCK locks » Display locks and latches » Show rollback segment stats » Show active transactions » List supported INIT.ORA parameters » Display database SGA statistics » Measure the Buffer Cache Hit Ratio » List security related profile informat... » Audit User Logins (User Login Trigger) » Block TOAD and other tools » Kill Session » Extents » DBA Users » DBA Tablespaces » DBA triggers » DBA Sessions » DBA Roles » DBA Objects » DBA Links » DBA Jobs » Job Queue » DBA Free Space » Data Files » DBA Extents
conn / AS sysdba 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', 'IFSSYS$CM', 'MDSYS', 'ORDPLUGINS', 'ORDSYS', 'TIMESERIES_DBA') /
