Scripts

Here you find some Scripts I wrote or co-authored. The scripts are available free to anyone to use. I do not accept any responsibility for any damage, errors or anything whatsoever caused by running or using these scripts. The scripts have been tested thoroughly but as there are many platforms, oracle versions and possible configurations, it does not mean that they will work for you when they work for me. Please review the file header for further information on the scripts, references etc before running them especially on production system.

 Page 1 of 2  1  2  » 


Date Title Language
24. November 2017 verify_password_hash.sql
(Size 11.2 KiB / Hits 41)
Check if user has a weak password.
24. November 2017 verify_passwords.sql
(Size 14.1 KiB / Hits 38)
Check if user in sys.user$ has a weak DES based password. Base Script for verify_alluser_passwords.sql, verify_alluser_passwords_no.sql, verify_user_password.sql and verify_user_password_no.sql.
24. November 2017 verify_alluser_passwords_no.sql
(Size 1.4 KiB / Hits 39)
Wrapper script to check if any user in sys.user$ has a weak DES based password. Passwords will not be displayed.
24. November 2017 verify_alluser_passwords.sql
(Size 1.4 KiB / Hits 40)
Wrapper script to check if a user has a weak DES based password. Passwords will not be displayed
24. November 2017 verify_user_password_no.sql
(Size 1.4 KiB / Hits 39)
Wrapper script to check if a user has a weak password. Passwords will not be displayed.
24. November 2017 verify_user_password.sql
(Size 1.4 KiB / Hits 39)
Wrapper script to check if a user has a weak password. Passwords will be displayed
24. November 2017 create_password_hash.sql
(Size 4.5 KiB / Hits 39)
Calculate Oracle DES based password hash from username and password
24. November 2017 aui.sql
(Size 1.7 KiB / Hits 37)
Script to show authentication information of the connected user and from its USERENV context.
24. November 2017 07_tsdp_audit.sql
(Size 8.5 KiB / Hits 37)
Transparent Sensitive Data Protection and Data Redaction demo
24. November 2017 06_tsdp_redact.sql
(Size 5.7 KiB / Hits 41)
Transparent Sensitive Data Protection and Data Redaction demo
24. November 2017 05_redaction.sql
(Size 3.4 KiB / Hits 36)
Oracle Data Redaction demo script
24. November 2017 04_audit.sql
(Size 3.6 KiB / Hits 37)
Unified audit demo script
24. November 2017 03_vpd.sql
(Size 4.0 KiB / Hits 41)
Virtual Private Database demo with default and column masking.
24. November 2017 02_privileges.sql
(Size 3.8 KiB / Hits 57)
Database privileges analysis demo
24. November 2017 01_authentication.sql
(Size 11.0 KiB / Hits 51)
Short example to demonstrate the different authentication and user types.
13. November 2017 oudbase_install.sh
(Size 20.6 KiB / Hits 454)
OUD Environment Installation Script (including TAR). Now also on GitHub https://github.com/oehrlis/oudbase
13. November 2017 oudbase_install.tgz
(Size 10.4 KiB / Hits 140)
OUD Environment scripts for manual installation
4. September 2015 connect_scott.sql
(Size 283.4 KiB / Hits 827)
Test script to test the SHA512 Memory Leak issue.
4. September 2015 connect_scott_template.sql
(Size 290 bytes / Hits 807)
Template to create the test SQL Script with a bunch of connects
14. October 2013 dbl.sql
(Size 1.7 KiB / Hits 1,307)
Script to query database links
3. April 2013 rj.sql
(Size 1.9 KiB / Hits 1,638)
rman