Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle data dictionary scripts in this concise download.  With decades of experience using Oracle role scripts, Oracle row-level security scripts, Oracle virtual private database scripts, and oracle grant execute scripts, Mike Ault shares secrets for navigating the Oracle data dictionary.

This fantastic download allows you to quickly find working Oracle scripts for Working Oracle scripts using dba_col_privs, dba_policies, dba_role_privs, dba_roles, dba_sys_grants, dba_sys_privs, dba_tab_privs, dba_ts_quotas, dba_users, sys.user$, v$parameter, v$session, v$timer, v$queue, v$dispatcher, v$database and v$sqltext.

Caution - These are extremely powerful Oracle data dictionary scripts.  They should only be used by a certified Oracle DBA, and after a careful review of the Oracle data dictionary script functionality.  These Oracle scripts are not for beginners and knowledge of the Oracle data dictionary is required to fully utilize these scripts.  USE AT YOUR OWN RISK.

Key Features:

• Provides Oracle security audit scripts and Oracle security auditing scripts using dba_col_privs, dba_policies, dba_role_privs, dba_roles, dba_sys_grants, dba_sys_privs and dba_tab_privs.

• Oracle user resource scripts using dba_policies, dba_ts_quotas dba_users and sys.user$.

• Detailed Oracle auditing scripts using v$parameter, v$session, v$timer, v$queue, v$dispatcher, v$database and v$sqltext.

About the Author:

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.