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 685)
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,616)
Check if user has a weak password.
24. November 2017 verify_passwords.sql
(Size 14.1 KiB / Hits 1,837)
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,473)
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,640)
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,282)
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,321)
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,732)
Calculate Oracle DES based password hash from username and password
24. November 2017 aui.sql
(Size 1.7 KiB / Hits 1,200)
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,244)
Transparent Sensitive Data Protection and Data Redaction demo
24. November 2017 06_tsdp_redact.sql
(Size 5.7 KiB / Hits 1,293)
Transparent Sensitive Data Protection and Data Redaction demo
24. November 2017 05_redaction.sql
(Size 3.4 KiB / Hits 1,029)
Oracle Data Redaction demo script
24. November 2017 04_audit.sql
(Size 3.6 KiB / Hits 1,193)
Unified audit demo script
24. November 2017 03_vpd.sql
(Size 4.0 KiB / Hits 1,072)
Virtual Private Database demo with default and column masking.
24. November 2017 02_privileges.sql
(Size 3.8 KiB / Hits 1,212)
Database privileges analysis demo
24. November 2017 01_authentication.sql
(Size 11.0 KiB / Hits 1,246)
Short example to demonstrate the different authentication and user types.
4. September 2015 connect_scott.sql
(Size 283.4 KiB / Hits 1,869)
Test script to test the SHA512 Memory Leak issue.
4. September 2015 connect_scott_template.sql
(Size 290 bytes / Hits 1,704)
Template to create the test SQL Script with a bunch of connects
14. October 2013 dbl.sql
(Size 1.7 KiB / Hits 2,243)
Script to query database links
3. April 2013 rj.sql
(Size 1.9 KiB / Hits 2,766)
rman