23.8.1 Enabling Data Redaction in case of Upgrade

This section details about the configurations required in case you want to enable Data Redaction in OFSAA applications after upgrade to OFSAA 8.0.8.0.0 version from a previous version. Additionally, these configurations are required in case you did not enable TDE during OFS Sanctions 8.0.8.0.0 installation and want to enable at a later point of time.

Perform the following steps:

1. Login as SYSDBA into the database.
2. Execute the $FIC_HOME/utility/data_security/scripts/create_data_sec_roles.sql file only once per database (PDB in case of 12c).
3. Execute the following sql statement to find out the list of atomic users from the table:

   select v_schema_name from aai_db_detail where V_DB_NAME 'CONFIG' AND V_DB_TYPE = 'ORACLE'

4. Execute the $FIC_HOME/utility/data_security/scripts/grant_data_sec_roles.sql file for all atomic users found in the previous step.
5. From the Configuration window in the System Configuration module, select Allow Data Redaction checkbox.
6. Run the Data Redaction utility. For more details on how to run the utility, see the Data Redaction section in Oracle Financial Services Advanced Analytical Applications Infrastructure Application Pack Installation and Configuration Guide.