Data Redaction Grants to Sandbox Schema

The configuration discussed in this section is required if you have selected Data Redaction while installing OFSAA. Data Redaction is an Advanced Security option (see Data Redaction for more details). You have to give grants related to Data Redaction to the Sandbox schema for model execution to execute.

Perform the following procedure to give grants for Data Redaction to the Sandbox Schema:

1. Login with System Database Administrator (SYSDBA) rights to the database where the Sandbox Schema is created.
2. Give the following Grants:
   grant execute on DBMS_REDACT to &atomicUser
   /
   Create role OFS_SEC_DATA
   /
   grant OFS_SEC_DATA to &atomicUser
   /
   create role OFS_NOSEC_DATA
   /
   grant EXEMPT REDACTION POLICY to OFS_NOSEC_DATA
   /
   grant OFS_NOSEC_DATA to &atomicUser
   /
   alter user &atomicUser default role none