Update Security Assignments Automatically

As a security administrator, automate the updating of security assignments to effectively manage the regular security assignment changes in your organization.

If you want to automate the insertion and deletion of data in the format of USERNAME, SEC_OBJ_CODE, SEC_OBJ_MEMBER_VAL, Operation (to add or to remove the mapping), then configure the changes in the security assignments to be updated automatically and regularly.

To ensure that the changes in security assignment are updated automatically, you must create a table for the OAX_USER schema in Oracle Autonomous Data Warehouse associated with your Oracle Fusion Data Intelligence instance. Ensure that you name the table "CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT". You must seed data into this table regularly with the timestamp in universal time (UTC) format in the "CREATION_DATE" column of the table. The CREATION_DATE column ensures that the same records aren't processed repeatedly and no record is missed. Oracle Fusion Data Intelligence periodically scans the synonym (2 hours once), pick up the values, and based on the "CREATION_DATE" criteria, populates the FAW_CONTENT_AUTOSYNC_ASSIGNMENT table in the OAX$INFRA schema in Oracle Autonomous Data Warehouse. Later, Oracle Fusion Data Intelligence processes the data and uploads the security assignments as per the FAW_CONTENT_AUTOSYNC_ASSIGNMENT table.

1. In Oracle Autonomous Data Warehouse associated with your Oracle Fusion Data Intelligence instance, create the CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT table in OAX_USER schema using the following script:

   CREATE TABLE CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT (
       "USERNAME"           VARCHAR2(256 CHAR),
       "SEC_OBJ_CODE"       VARCHAR2(256 CHAR),
       "SEC_OBJ_MEMBER_VAL" VARCHAR2(4000 CHAR),
       "OPERATION_TYPE"     VARCHAR2(65 CHAR),
       "CREATION_DATE"      TIMESTAMP(6)
   );
   
   -- Grant access from the schema OAX_USER
   
   GRANT SELECT ON CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT TO OAX$INFRA;
   COMMIT;

2. In the CUSTOMER_FAW_CONTENT_AUTOSYNC_ASSIGNMENT table, specify the actual values for "USERNAME", "SEC_OBJ_CODE", "SEC_OBJ_MEMBER_VAL", "OPERATION_TYPE", and "CREATION_DATE". For "OPERATION_TYPE", enter "ADD" and enter the timestamp in "CREATION_DATE" in "2024-02-21 12:34:56.789" format.