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.
| Date | Title | Language |
|---|---|---|
| 24. January 2018 |  oudbase_install.tgz (Size unknown / Hits 738) |
OUD Environment scripts for manual installation. As of now latest release is available via GitHub. |
| 24. January 2018 | oudbase_install.sh (Size unknown / Hits 775) |
OUD Environment Installation Script (including TAR). Now also on GitHub https://github.com/oehrlis/oudbase |
| 24. November 2017 | verify_password_hash.sql (Size 11.2 KiB / Hits 1,722) |
Check if user has a weak password. |
| 24. November 2017 | verify_passwords.sql (Size 14.1 KiB / Hits 2,026) |
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 1,598) |
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 1,889) |
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 1,403) |
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 1,445) |
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 1,871) |
Calculate Oracle DES based password hash from username and password |
| 24. November 2017 | aui.sql (Size 1.7 KiB / Hits 1,314) |
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 1,344) |
Transparent Sensitive Data Protection and Data Redaction demo |
| 24. November 2017 | 06_tsdp_redact.sql (Size 5.7 KiB / Hits 1,402) |
Transparent Sensitive Data Protection and Data Redaction demo |
| 24. November 2017 | 05_redaction.sql (Size 3.4 KiB / Hits 1,134) |
Oracle Data Redaction demo script |
| 24. November 2017 | 04_audit.sql (Size 3.6 KiB / Hits 1,320) |
Unified audit demo script |
| 24. November 2017 | 03_vpd.sql (Size 4.0 KiB / Hits 1,184) |
Virtual Private Database demo with default and column masking. |
| 24. November 2017 | 02_privileges.sql (Size 3.8 KiB / Hits 1,322) |
Database privileges analysis demo |
| 24. November 2017 | 01_authentication.sql (Size 11.0 KiB / Hits 1,356) |
Short example to demonstrate the different authentication and user types. |
| 4. September 2015 | connect_scott.sql (Size 283.4 KiB / Hits 1,980) |
Test script to test the SHA512 Memory Leak issue. |
| 4. September 2015 | connect_scott_template.sql (Size 290 bytes / Hits 1,831) |
Template to create the test SQL Script with a bunch of connects |
| 14. October 2013 | dbl.sql (Size 1.7 KiB / Hits 2,333) |
Script to query database links |
| 3. April 2013 | rj.sql (Size 1.9 KiB / Hits 2,869) |
rman |