A Sample Scripts for Configuring Oracle Deep Data Security

Use the SQL scripts in this appendix to automate the three quick-start scenarios in Part II of this guide.

The scripts are grouped by scenario:

• Section A.1 provides the scripts for Configure Oracle Deep Data Security for Direct Logon with Local End Users.
• Section A.2 provides the scripts for Configure Oracle Deep Data Security for Direct Logon with End Users in IAM.
• Section A.3 provides the scripts for Configure Oracle Deep Data Security for a Sample Application.

Each section contains a demo script that creates the demo environment and a cleanup script that removes all objects the demo script created. The corresponding log files capture the output of running each script.

See the respective chapter for the full configuration walkthrough and an explanation of the scenario.

Before you begin

• You must have the SYS password for the target pluggable database (PDB).
• For the scenarios in Section A.2 and Section A.3, you must have completed the Microsoft Entra ID configuration steps described in the corresponding chapter.

About the scripts

Each demo script connects as SYS to create a helper administrative user named DEEPSEC_DBA, which then performs the DBA-level steps the corresponding chapter (in Part II) performs interactively as a named DBA user. The cleanup scripts also connect as SYS to drop DEEPSEC_DBA. Supply the SYS password as the first argument to every script.