5.1.6.5 Redaction DDLs [Data Definition Language]

Starter kit bundles redaction policy ddls for all the objects extracted as part of Starter Kit Generation. Redaction policy DDLs will be extracted and bundled as part of Starter Kit only if a redaction policy is enforced for an object using the redaction framework UI.

Please refer to Data Redaction on how to enable redaction using redaction framework user interface.

How to use the redaction policy DDLs bundled in the Starter Kit [Optional]:

• Redaction policy DDLs are bundled in a separate folder named redaction in the Starter Kit.
• Redaction policy DDLs can be executed in the schema where Starter Kit bundled objects are installed.
• Redaction policy DDLs are NOT executed as part of Starter Kit installation and needs to be executed manually.

Steps to execute:

1. Copy the redaction.sql available in the redaction folder to any user specified folder.
2. Login to database schema user where Starter Kit objects are installed.

   Example: sqlplus <schema_username>/<schema_password> @<db_service_name>

3. For logging enable spooling of execution logs:

   Example: spool <absolute_folderpath_for_logging>/redaction.log

4. Execute the redaction.sql from the sqlplus prompt.

   Example: @<absolute_path_of_redaction.sql>