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:
-
Select Navigator> Security Console.
-
Click Manage Database Resources.
-
Enter the criteria to search for an object (or database resource) and click Search.
-
Select object for which you want to create data privileges.
-
From the Actions menu, select Edit.
The Edit Data Security page appears.
-
Click the Actions tab.
-
Click Add to create a new data privilege.
-
Enter the name of the data privilege, display name and description.
-
Click Submit.
If the Manage Database Resources button is disabled, follow these instructions to enable the button:
-
Select Navigator > Security Console.
-
Search for the relevant role and edit that role.
-
In Functional Security Policy, click Add Function Security Policy.
-
Search for the Enable Database Resource Management privilege.
-
Click Add Privilege to Role and click Next.
-
In Summary and Impact Report, click Save.