Configure Data Security Policy

You must create a data security policy for the required role.

Here's how you can configure data security policy for a subscription account note:

1. Go to Navigator > Tools > Security Console.

   Note: You require the IT security manager job role to complete the task.

2. Click Administration tab.

3. Click Manage Database Resources.

4. Search for zmm_notes on the Manage Database Resources and Policies page.

5. Select the object from the search result and click Edit.

6. Navigate to Condition tab and click Create.

7. Enter the following information in the Create Database Resource Condition dialog box and click Save.

   Name: SUBSCRIPTION_ACCOUNT_NOTE

   Display Name: Access Notes created in Subscription Accounts.

   Condition Type: SQL predicate

   SQL predicate: &TABLE_ALIAS.source_object_code = 'SUBSCRIPTION_ACCOUNT' AND ((VISIBILITY_CODE IN ('INTERNAL', 'EXTERNAL')) OR (VISIBILITY_CODE = 'PRIVATE' AND &TABLE_ALIAS.CREATED_BY = FND_GLOBAL.USER_NAME))

8. Navigate to the Policy tab and click Create.

9. Enter the following information on the Create Policy dialog box:

   1. General Information tab:

      1. Name: Grant on Auto Subscription Account Note

      2. Start Date: Select a start date according to the requirements of your organization.

   2. Role tab:

      1. Click Add and search for the roles you created.

      2. Select these roles from the search result and click OK.

      3. Rule tab:

         1. Row Set: Multiple Values

         2. Condition: Access Notes created in Subscription Account.

      4. Navigate to the Action tab and move appropriate permissions such as read or update or delete to the Selected Actions section for all the objects.

      5. Click Save and Close.

10. Click Submit.