REQUIRED_ROLE_FOR_DMW

To manage Object Security in Oracle DMW, you'll need to assign REQUIRED_ROLE_FOR_DMW to an Administrator. The Oracle LSH Object permissions required to use Oracle DMW's Security interface are automatically assigned to this role.

Object Type Object Security Permissions
Adapter Area
  • Classify
  • Create Business Area
  • Create Data Mart
  • Create Notification
  • Create Parameter Set
  • Create Program
  • Create Remote Location
  • Create Remote Area
  • Create Table
  • Create Variable
  • Create Work Area
  • Create Workflow
  • Create Webservice Location
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Adapter Domain
  • Classify
  • Create Adapter Area
  • Create Business Area
  • Create Data Mart
  • Create Load Set
  • Create Notification
  • Create Parameter
  • Create Parameter Set
  • Create Program
  • Create Table
  • Create Variable
  • Create Workflow Structure
  • Create Workflow
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Application Area
  • Classify
  • Create Business Area
  • Create Data Mart
  • Create Load Set
  • Create Notification
  • Create Parameter
  • Create Parameter Set
  • Create Program
  • Create Table
  • Create Variable
  • Create Work Area
  • Create Workflow
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Business Area
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Business Area Instance
  • Classify
  • Delete
  • Manage GVA BA Database Access
  • Modify
  • Modify Supporting Info
  • Read Business Area Instance
  • Read(Unblind) Business Area Instance
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Variable
  • Classify
  • Delete Variable
  • Modify Variable
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View Variable
Data Mart
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Data Mart Instance
  • Classify
  • Create Execution Setup
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Execution Set-Up
  • Classify
  • Delete
  • IQ Submit
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Submit
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Instance Domain
  • Create Adapter Domain
  • Create Library Domain
  • Modify
  • Manage Security
  • View
Loadset
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Loadset Instance
  • Classify
  • Create Execution Setup
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Notification
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Output
  • Annotate
  • Blind Break
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Read Data
  • Read Unblind
  • Manage Security
  • Unblind
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Parameter
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Parameter Set
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Program
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Program Instance
  • Classify
  • Create Execution Setup
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Table
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Table Instance
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Work Area
  • Classify
  • Clone
  • Create Business Area Instance
  • Create DataMart Instance
  • Create LoadSet Instance
  • Create Program Instance
  • Create Table Instance
  • Create Workflow Instance
  • Delete
  • Install
  • Install Qualify Submit
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Workflow
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Workflow Instance
  • Classify
  • Create Execution Setup
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View
Workflow Structure
  • Classify
  • Delete
  • Modify
  • Modify Supporting Info
  • Manage Security
  • Modify Validation Status Production
  • Modify Validation Status QC
  • View

Parent topic: Predefined object security roles