Difference between revisions of "Handy scripts"
From dbawiki
| Line 2: | Line 2: | ||
*[[Database Overview - from idevelopment]] [http://www.idevelopment.info/data/Oracle/DBA_scripts/Database_Administration/dba_snapshot_database_10g.sql online version] | *[[Database Overview - from idevelopment]] [http://www.idevelopment.info/data/Oracle/DBA_scripts/Database_Administration/dba_snapshot_database_10g.sql online version] | ||
*[http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:83012348058 Connecting as another user via proxy in SQL*Plus] | *[http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:83012348058 Connecting as another user via proxy in SQL*Plus] | ||
| − | *[http://www.petefinnigan.com/tools.htm | + | *[http://www.petefinnigan.com/tools.htm 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 | ||
==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:43, 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
