Stored Procedure Accelerator Guide for Oracle

9.9.1
- 9.9.3
- 9.9.2
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Stored Procedure Accelerator Maintenance

Remove tables in the temporary database schema or use the clean up script template to create an Oracle job that cleans up the temporary objects that the accelerator creates in the temporary schema as part of the masking process.

To mask stored procedures, Dynamic Data Masking dynamically creates tables and temporary stored procedures in the Oracle temporary schema that the Dynamic Data Masking user configures. Because the tables are global temporary tables, the tables do not contain data.

When you set up the accelerator, you can create the CLEANUP_TEMP_OBJECTS procedure and schedule the procedure job to drop the tables and stored procedures. If you do not create the procedure, you must periodically manually drop the tables and stored procedures in the temporary schema.

Masking Stored Procedures and User-Defined Table Functions

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal