Difference between revisions of "Handy scripts"
From dbawiki
| Line 15: | Line 15: | ||
DBA_WM_SYS_PRIVS | DBA_WM_SYS_PRIVS | ||
DBA_WORKSPACE_PRIVS | DBA_WORKSPACE_PRIVS | ||
| + | |||
| + | ===badprivs.sql=== | ||
| + | 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') | ||
| + | |||
==shell== | ==shell== | ||
==cmd== | ==cmd== | ||
*[http://www.dba-oracle.com/t_scripts_windows_export.htm Database Export - from DBA Oracle (Burleson)] | *[http://www.dba-oracle.com/t_scripts_windows_export.htm Database Export - from DBA Oracle (Burleson)] | ||
Revision as of 12:46, 5 September 2012
SQL
- Database Overview - from idevelopment online version
- Connecting as another user via proxy in SQL*Plus
- Password cracker and role and priv tools from Pete Finnigan
DBA privs tables
DBA_AQ_AGENT_PRIVS DBA_COL_PRIVS DBA_PRIV_AUDIT_OPTS DBA_REPGROUP_PRIVILEGES DBA_ROLE_PRIVS DBA_RSRC_CONSUMER_GROUP_PRIVS DBA_RSRC_MANAGER_SYSTEM_PRIVS DBA_SYS_PRIVS DBA_TAB_PRIVS DBA_WM_SYS_PRIVS DBA_WORKSPACE_PRIVS
badprivs.sql
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')
