Difference between revisions of "Handy scripts"
From dbawiki
| Line 3: | Line 3: | ||
*[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 Password cracker and role and priv tools from Pete Finnigan] | *[http://www.petefinnigan.com/tools.htm Password cracker and role and priv tools from Pete Finnigan] | ||
| − | DBA privs tables | + | ===DBA privs tables=== |
| − | DBA_AQ_AGENT_PRIVS | + | DBA_AQ_AGENT_PRIVS |
| − | DBA_COL_PRIVS | + | DBA_COL_PRIVS |
| − | DBA_PRIV_AUDIT_OPTS | + | DBA_PRIV_AUDIT_OPTS |
| − | DBA_REPGROUP_PRIVILEGES | + | DBA_REPGROUP_PRIVILEGES |
| − | DBA_ROLE_PRIVS | + | DBA_ROLE_PRIVS |
| − | DBA_RSRC_CONSUMER_GROUP_PRIVS | + | DBA_RSRC_CONSUMER_GROUP_PRIVS |
| − | DBA_RSRC_MANAGER_SYSTEM_PRIVS | + | DBA_RSRC_MANAGER_SYSTEM_PRIVS |
| − | DBA_SYS_PRIVS | + | DBA_SYS_PRIVS |
| − | DBA_TAB_PRIVS | + | DBA_TAB_PRIVS |
| − | DBA_WM_SYS_PRIVS | + | DBA_WM_SYS_PRIVS |
| − | DBA_WORKSPACE_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:45, 5 September 2012
Contents
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
