Create Data Privileges for Attribute Groups

User defined attribute groups are supported by following tables at the following data levels:

Non-translatable tables:

  • Item Data Level - EGO_ITEM_EFF_B

  • Item Revision Data Level - EGO_ITEM_REVISION_EFF_B

  • Item Supplier Data Level - EGO_ITEM_SUPPLIER_EFF_B

Translatable tables:

  • Item Data Level Translatable - EGO_ITEM_EFF_VL

  • Item Revision Data Level Translatable - EGO_ITEM_REVISION_EFF_VL

  • Item Supplier Data Level Translatable - EGO_ITEM_SUPPLIER_EFF_VL

To create data privileges for attribute groups:

  1. Select Navigator> Security Console.

  2. Click Manage Database Resources.

  3. Enter the criteria to search for an object (or database resource) and click Search.

  4. Select object for which you want to create data privileges.

  5. From the Actions menu, select Edit.

    The Edit Data Security page appears.

  6. Click the Actions tab.

  7. Click Add to create a new data privilege.

  8. Enter the name of the data privilege, display name and description.

  9. Click Submit.

If the Manage Database Resources button is disabled, follow these instructions to enable the button:

  1. Select Navigator > Security Console.

  2. Search for the relevant role and edit that role.

  3. In Functional Security Policy, click Add Function Security Policy.

  4. Search for the Enable Database Resource Management privilege.

  5. Click Add Privilege to Role and click Next.

  6. In Summary and Impact Report, click Save.