Minor Release Update

Added

• Add script spsec_usrinf.sql to show session information of current user
• Add alias script whoami.sql for script spsec_usrinf.sql

Minor Release Update

Added

• Add script sdenc_dbf_off_enc.sql to generate chunks of alter database commands for offline encrypt datafiles
• Add script sdenc_dbf_off_dec.sql to generate chunks of alter database commands for offline decrypt datafiles
• Add script saua_logon.sql to show audit logon events
• Add script senc_tde_ops.sql to show TDE operation from V$SESSION_LONGOPS.
• Add script senc_tde_ops_run.sql to show running TDE operation from V$SESSION_LONGOPS.
• Add script senc_tde_ops_csv.sql to show TDE operation from V$SESSION_LONGOPS as CSV

Minor Release Update

Added

• Add a script saua_report.sql to run all show / report queries for unified audit in one script. Depending on the amount of audit data, this script can run for a relatively long time.

Changed

• add SPOOL to all show script for Oracle Unified Audit

Minor Release Update

Added

• add a generic password verify function cssec_pwverify.sql The password strength and complexity can be configured by the internal variables at create time
• Script sssec_pwverify_test.sql to verify the custom password verify function. List of passwords to be tested have to added to the script / varchar2 array

Minor Release Update

Added

• add script csenc_swkeystore_backup.sql to create a TDE software keystore backup using DBMS_SCHEDULER
• add script ssenc_swkeystore_backup.sql to show TDE software keystore backup schedules created with csenc_swkeystore_backup.sql
• add script dsenc_swkeystore_backup.sql to delete TDE software keystore backup schedules created with csenc_swkeystore_backup.sql

Changed

• rename file isenc_tde_pdbiso_syskm.sql to isenc_tde_pdbiso_keyadmin.sql
• add add grant privileges for key management to isenc_tde_pdbiso_prepare.sql

Minor Release Update

Added

• add script isenc_tde_pdbiso_prepare.sql to prepare a PDB environment for isolated mode
• add script isenc_tde_pdbiso_syskm.sql to configure PDB software keystore as SYSKM

Changed

• update documentation for new scripts

Bugfix Release due to wrong filenames in 1.1.0

Minor Bugfix Release due to wrong filenames in 1.1.0

Fixed

• fix name for the files from idenc_tde.sql, idenc_tde_pdbuni.sql,
  idenc_tde_pdbiso.sql to isenc_tde.sql, isenc_tde_pdbuni.sql,
  isenc_tde_pdbiso.sql

Minor Release Update for TDE

Minor release update for the TDE configuration scripts.

Added

• add script idenc_wroot.sql to initialize init.ora parameter WALLET_ROOT for
  TDE with software keystore.
• add script csenc_master.sql to create master encryption key for TDE.
  Configured keystore must be set before hand e.g., with csenc_swkeystore.sql.
  Works for CDB as well PDB.
• add script csenc_swkeystore.sql to create TDE software keystore and master
  encryption key in CDB$ROOT in the WALLET_ROOT directory.
• add script ddenc_wroot.sql to reset init.ora parameter WALLET_ROOT for TDE.
  This script should run in CDB$ROOT. A manual restart of the database is
  mandatory to activate WALLET_ROOT
• add script idenc_lostkey.sql to set hidden parameter _db_discard_lost_masterkey
  to force discard of lost master keys
• add script idenc_tde_pdbiso.sql to initialize TDE in a PDB in isolation mode
  i.e., with a dedicated wallet in WALLET_ROOT for this pdb. The CDB must be
  configured for TDE beforehand. This scripts does use several other scripts to
  enable TDE and it also includes restart of the pdb.
• add script idenc_tde_pdbuni.sql to initialize TDE in a PDB in united mode
  i.e., with a common wallet of the CDB in WALLET_ROOT. The CDB must be
  configured for TDE beforehand. This scripts does use several other scripts to
  enable TDE and it also includes restart of the pdb.
• add script idenc_tde.sql to initialize TDE for a single tenant or container
  database. This scripts does use several other scripts to enable TDE and it
  also includes restart of the database.
• add script ssenc_info to show information about the TDE Configuration.

Changed

• update README.md with information for latest scripts.

Minor Release Update

Added

• add delete TDE script dsenc_tde.sql
• add a force TDE setup script isenc_tde_force.sql which explicitly discard
  lost master key handles.
• add a force TDE setup script isenc_tde_pdbiso_force.sql which explicitly
  discard lost master key handles.
• add a force TDE setup script isenc_tde_pdbuni_force.sql which explicitly
  discard lost master key handles.

Changed

• remove prompt csenc_master.sql
• simplify commands and remove one db startup force in csenc_swkeystore.sql
• simplify commands and remove one db startup force in isenc_tde.sql
• simplify commands and remove one db startup force in isenc_tde_pdbiso.sql
• move legacy scripts back to sql folder

Major Release for SQL Audit Toolbox

Build new major release after official releasing the SQL toolbox for simplified Oracle Unified Audit Data Analysis. See blog post on oradba.ch

Added

• Readme for SQL Toolbox for simplified Oracle Unified Audit Data Analysis
• add latest version (v3.4.8) of TNS scripts

Changed

• Adjust script names according naming convention
• Clean up file headers