|
check_parameter.sql |
Discription:
Use this script to find the value of an Oracle initialisation parameter. It handles undocument ("_" underscore) parameters as well as normal ones. You can also pass in the value that the parameter should have and the procedure indicates if the setting violates this or not. The output can be directed to either the screen via dbms_output or to a file via utl_file. The method is decided at run time by choosing either 'S' for screen or 'F' for File. If File is chosen then a filename and output directory are needed. The output directory needs to be enabled via utl_file_dir prior to 9iR2 and a directory object after.
|
free | Plateform(s): Linux | Update: 12/30/200 | Vistor Rating: 3 | Rating: 3 |
find_all_privs.sql |
Discription:
Use this script to find which privileges have been granted to a particular user. This scripts lists ROLES, SYSTEM privileges and object privileges granted to a user. If a ROLE is found then it is checked recursively.The output can be directed to either the screen via dbms_output or to a file via utl_file. The method is decided at run time by choosing either 'S' for screen or 'F' for File. If File is chosen then a filename and output directory are needed. The output directory needs to be enabled via utl_file_dir prior to 9iR2 and a directory object after.
|
free | Plateform(s): Linux | Update: 12/30/200 | Vistor Rating: 4 | Rating: 3 |
who_has_priv.sql |
Discription:
Use this script to find which users have been granted the privilege passed in. The script checks hierarchically for each user granted the privileges via a role.The output can be directed to either the screen via dbms_output or to a file via utl_file. The method is decided at run time by choosing either 'S' for screen or 'F' for File. If File is chosen then a filename and output directory are needed. The output directory needs to be enabled via utl_file_dir prior to 9iR2 and a directory object after.
|
free | Plateform(s): Linux | Update: 12/30/200 | Vistor Rating: 4 | Rating: 3 |
DBA Sample Scripts |
Discription:
Generic Scipts covering Oracle Database 10g Release 2 and later
|
11g | Plateform(s): Linux | Update: 12/3/2008 | Vistor Rating: 1 | Rating: 1 |
Oracle Scripts |
Discription:
Oracle Backup and Recovery methods
|
9i | Plateform(s): Linux | Update: 12/4/2008 | Vistor Rating: 2 | Rating: 1 |
|
|
|
|