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. January 2018 oudbase_install.tgz
(Size unknown / Hits 183)
OUD Environment scripts for manual installation
24. January 2018 oudbase_install.sh
(Size unknown / Hits 531)
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 131)
Check if user has a weak password.
24. November 2017 verify_passwords.sql
(Size 14.1 KiB / Hits 121)
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 115)
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 121)
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 117)
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 119)
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 124)
Calculate Oracle DES based password hash from username and password
24. November 2017 aui.sql
(Size 1.7 KiB / Hits 126)
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 131)
Transparent Sensitive Data Protection and Data Redaction demo
24. November 2017 06_tsdp_redact.sql
(Size 5.7 KiB / Hits 134)
Transparent Sensitive Data Protection and Data Redaction demo
24. November 2017 05_redaction.sql
(Size 3.4 KiB / Hits 128)
Oracle Data Redaction demo script
24. November 2017 04_audit.sql
(Size 3.6 KiB / Hits 132)
Unified audit demo script
24. November 2017 03_vpd.sql
(Size 4.0 KiB / Hits 137)
Virtual Private Database demo with default and column masking.
24. November 2017 02_privileges.sql
(Size 3.8 KiB / Hits 174)
Database privileges analysis demo
24. November 2017 01_authentication.sql
(Size 11.0 KiB / Hits 147)
Short example to demonstrate the different authentication and user types.
4. September 2015 connect_scott.sql
(Size 283.4 KiB / Hits 882)
Test script to test the SHA512 Memory Leak issue.
4. September 2015 connect_scott_template.sql
(Size 290 bytes / Hits 862)
Template to create the test SQL Script with a bunch of connects
14. October 2013 dbl.sql
(Size 1.7 KiB / Hits 1,360)
Script to query database links
3. April 2013 rj.sql
(Size 1.9 KiB / Hits 1,696)
rman