You can use shipped, predefined object security and application roles to simplify security setup.
Predefined Oracle DMW Application Roles
Each user must have at least one of the following application roles to access the Oracle DMW user interface.
DMW_STUDY_MANAGER
DMW_STUDY_MANAGER is intended for users who run data loads, transformations, and validation checks. It provides access to the Home, Study Configuration, Listings, and Discrepancies pages.
Users with this role can create, modify, and remove studies in the Home page.
DMW_STUDY_CONFIG
DMW_STUDY_CONFIG is intended for users who set up studies by defining models, transformations, and validation checks. It provides access to the Home, Study Configuration, Listings, and Discrepancies pages.
Users with this role can create, modify, and remove studies in the Home page.
Note:
There is no functional difference between the application roles DMW_STUDY_MANAGER and DMW_STUDY_CONFIG.
DMW_STUDY_CONSUMER
DMW_STUDY_CONSUMER is intended for users who need to review data and raise discrepancies. It provides access to the Home, Listings, and Discrepancies pages.
DMW_LIB_ADMIN
DMW_LIB_ADMIN is intended for users who create and modify library models and code lists. It provides access only to the Library page.
DMW_SYS_ADMIN
DMW_SYS_ADMIN is intended for users who do administrative tasks including setting up data sources and defining objects used across studies, such as categories, flags, and tags. It provides access only to the Administration page.
Predefined Blinding-Related Roles
Some Oracle DMW users should have blinding-related privileges in order to view blinded data and/or unblind data. This requires both a blinding-related application role and blinding-related object security privileges through a role in a user group assigned to the object, plus normal object security access to the object.
Since the Predefined Object Security Roles all include object-level access to blinded data, it is very important that you assign these application roles only to users who require them.
For more information about blinding data in Oracle LSH, see the Oracle Life Sciences Data Hub Implementation Guide and the Oracle Life Sciences Data Hub Application Developer's Guide.
LSH Data Blind Break User
Only the LSH Data Blind Administrator can assign this role to users. This role does not provide access to any parts of the user interface.
Users with this application role can do the following, if they have normal object security access and the blinding-related object security privilege noted:
-
Run a job on Tables with a Blinding Status of Blinded that displays the real data, not the dummy data (also requires an object security role with the Blind Break operation on Table instances)
-
View the output(s) generated by a job run on real, blinded data (also requires an object security role with the Blind Break operation on outputs)
LSH Data Unblind User
Only the LSH Data Blind Administrator can assign this role to users. This role does not provide access to any parts of the user interface.
Users with this application role can do the following, if they have normal object security access and the blinding-related object security privilege noted:
-
Permanently unblind data in Table instances (also requires an object security role with the Unblind operation on Table instances)
-
Change the status of an output from Blinded to Unblinded (also requires an object security role with the Unblind operation on outputs)
-
Note:
The LSH Data Unblind User application role is not required in conjunction with the Read Unblind operation on either Table instances or outputs. Users can have an object security role that includes the Read Unblind operation on Table instances (to run a job on unblinded Table instances) and/or outputs (to view the results of such a job) without having the LSH Data Unblind User application role as well.
Predefined Object Security Roles
In this appendix, each set of permissions is organized by the application for which the object type was originally created: Oracle LSH or Oracle DMW. Each permission granted by the role is presented in the format object type: operation.
Note:
Each role includes all blinding-related privileges. However, in order to perform blinding-related operations users must have blinding-related application roles as well; see
"Predefined Blinding-Related Roles".
The roles are:
DMW_STUDY_DEVELOPER
The DMW_STUDY_DEVELOPER object security role is intended for users who will configure studies by creating data models and creating and running transformations and validation checks. To test their work, they also need the ability to load data into the development lifecycle area from InForm and files, create custom listings, create and act on discrepancies, and assign flags to records. Blinding-related privileges are also included in this role.
Users with this role should have the DMW_STUDY_MANAGER or DMW_STUDY_CONFIG application role. If they need to create library data models they should also have the DMW_LIB_ADMIN application role.
DMW_STUDY_DEVELOPER allows users to perform the following operations on the specified objects.
Clinical Data Models and Query Builder
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for clinical data models and the query builder.
Oracle LSH Object Operations
Domain: Create Data Model
Domain: Create Load Set
Domain: Create Variable
Domain: View
Application Area: Create Work Area
Application Area: View
Load Set: View
Load Set: Modify
Load Set: Modify Val Status to QC
Load Set: Modify Val Status to PROD
Variable: Modify
Variable: Modify Val Status to QC
Variable: Modify Val Status to PROD
Table: View
Table: Modify
Work Area: Create Table Instance
Work Area: Create Load Set Instance
Work Area: Modify
Work Area: Modify Val Status to QC
Work Area: Modify Val Status to PROD
Work Area: Delete
Work Area: Deploy (Install)
Work Area: View
Load Set Instance: Modify
Load Set Instance: Modify Val Status to QC
Load Set Instance: Modify Val Status to PROD
Table Instance: Modify
Table Instance: Remove
Table Instance: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Oracle DMW Object Operations
Data Model: Modify
Data Model: Delete
Data Model: Publish Dev (used to install the Development Work Area)
Data Model: Modify Supporting Info
Data Model: Modify Val Status to QC
Data Model: Modify Val Status to PROD
Data Model: Create Private Listing
Data Model: Create Public Listing
Blinding
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for blinded data.
Oracle LSH Object Operations
Table Instance: ReadData
Table Instance: BlindBreak
Table Instance: Unblind
Table Instance: ReadUnblind
Filters
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operation for filters.
Oracle DMW Object Operations
Filter: Mark as Public in Dev
Data Lineage Tracing
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for data lineage tracing.
Oracle DMW Object Operations
Table Instance: View CTX Data Lineage
Transformations and Query Builder
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for transformations and the query builder.
Oracle LSH Object Operations
Application Area: Create Work Area
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Domain: Create Program
Domain: Create Variable
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program: Modify
Program: Remove
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Program Instance: Modify
Program Instance: Remove
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Table Instance: Modify Val Status to QC
Table Instance: BlindBreak
Table Instance: ReadData
Table Instance: ReadUnblind
Table Instance: Remove
Table Instance: Unblind
Table Instance: Modfiy
Table: Modify
Table: Remove
Table: View
Work Area: Create Program Instance
Work Area: Create Table Instance
Work Area: Deploy (Install)
Work Area: Modify
Work Area: Delete
Work Area: Modify Val Status to PROD
Work Area: Modify Val Status to QC
Oracle DMW Object Operations
Domain: Create Transformation Map
Data Model: Load Data in Development
Transformation Map: Modify
Transformation Map: Delete
Transformation Map: View
Transformation Map: Modify Validation Status QC
Transformation Map: Modify Validation Status Production
Transformation Map: Modify Supporting Info
Transformation Map: Deploy (Install) in Development
Transformation Map: Modify Security
Transformation Map: Classify
Discrepancies and Flags
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for discrepancies and flags.
Oracle DMW Object Operations
Table Instance: Create Manual Discrepancy
Table Instance: Close Discrepancy
Table Instance: Send Discrepancy to InForm
Table Instance: Send Discrepancy to Spreadsheet
Table Instance: Reopen Discrepancy
Table Instance: Answer Discrepancy
Table Instance: Cancel Discrepancy
Table Instance: Add Comment to Discrepancy
Table Instance: Edit Discrepancy
Table Instance: Show Discrepancies
Table Instance: Create Data Amendment
Table Instance: Modify Data Amendment
Table Instance: Cancel Data Amendment
Table Instance: Assign Flags
Validation Checks
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for validation checks.
Oracle LSH Object Operations
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Domain: Create Program
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program: Modify
Program: Remove
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Program Instance: Modify
Program Instance: Remove
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Table: Modify
Table: Remove
Work Area: Create Program Instance
Oracle DMW Object Operations
Data Model: Create VC Batch
VC Batch: Modify
VC Batch: Delete
VC Batch: View
VC Batch: Modify Validation Status QC
VC Batch: Modify Validation Status Production
VC Batch: Modify Supporting Info
VC Batch: Deploy (Install) in Development
VC Batch: Submit in Development
VC Batch: Submit Individual VC in Development
VC Batch: View Listings in Development
InForm
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for InForm clinical data models.
Oracle LSH Object Operations
Load Set Instance: Create Execution Setup
Program Instance: Create Execution Setup
Application Area: Create Program
Program: Modify
Program Instance: Modify
Oracle DMW Object Operations
Data Model: Load Data in Development
Data Model: Load InForm Metadata
Web Service Location: Modify Web Service Location
Web Service Location: Create Connection
File Watcher
Users assigned the DMW_STUDY_DEVELOPER role have access to the following operations for the File Watcher.
Oracle DMW Object Operations
Data Model: File Watcher Config
Data Model: Data Load DEV
DMW_STUDY_QC
The DMW_STUDY_QC object security role is intended for users who will conduct formal testing of study objects including data models, transformations, and validation checks. They also need the ability to load data into the Quality Control lifecycle area from InForm and files, create custom listings, create and act on discrepancies, and assign flags to records. Blinding-related privileges are also included in this role.
Users with this role should have the DMW_STUDY_MANAGER or DMW_STUDY_CONFIG application role.
DMW_STUDY_QC allows users to perform the following operations on the specified objects.
Clinical Data Models and Query Builder
Users assigned the DMW_STUDY_QC role have access to the following operations for clinical data models and the query builder.
Oracle LSH Object Operations
Work Area: Create Table Instance
Work Area: Create Load Set Instance
Work Area: Modify
Work Area: Modify Val Status to QC
Work Area: Modify Val Status to PROD
Work Area: Deploy (Install)
Table Instance: Modify
Table Instance: Remove
Table Instance: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Load Set Instance: Modify
Load Set Instance: Modify Val Status to QC
Load Set Instance: Modify Val Status to PROD
Oracle DMW Object Operations
Data Model: View
Data Model: Publish QC (used to install the QC Work Area)
Data Model: Modify Supporting Info
Data Model: Modify Val Status to QC
Data Model: Modify Val Status to PROD
Data Model: Create Private Listing
Filter: Mark Filter Public QC
Blinding
Users assigned the DMW_STUDY_QC role have access to the following operations for blinded data.
Oracle LSH Object Operations
Table Instance: ReadData
Table Instance: BlindBreak
Table Instance: Unblind
Table Instance: ReadUnblind
Discrepancies
Users assigned the DMW_STUDY_QC role have access to the following operations for discrepancies.
Oracle DMW Object Operations
Table Instance: Create Manual Discrepancy
Table Instance: Close Discrepancy
Table Instance: Send Discrepancy to InForm
Table Instance: Send Discrepancy to Spreadsheet
Table Instance: Reopen Discrepancy
Table Instance: Answer Discrepancy
Table Instance: Cancel Discrepancy
Table Instance: Add Comment to Discrepancy
Table Instance: Edit Discrepancy
Table Instance: Show Discrepancies
Table Instance: Create Data Amendment
Table Instance: Modify Data Amendment
Table Instance: Cancel Data Amendment
Filters
Users assigned the DMW_STUDY_QC role have access to the following operation for filters.
Oracle DMW Object Operations
Filter: Mark as Public in QC
Flags
Users assigned the DMW_STUDY_QC role have access to the following operations for flags.
Oracle DMW Object Operations
Table Instance: Assign Flags
Data Lineage Tracing
Users assigned the DMW_STUDY_QC role have access to the following operations for data lineage tracing.
Oracle DMW Object Operations
Table Instance: View CTX Data Lineage
Validation Checks
Users assigned the DMW_STUDY_QC role have access to the following operations for validation checks.
Oracle LSH Object Operations
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Work Area: Create Program Instance
Oracle DMW Object Operations
VC Batch: View
VC Batch: Modify Validation Status QC
VC Batch: Modify Validation Status Production
VC Batch: Modify Supporting Info
VC Batch: Deploy (Install) in Quality Control
VC Batch: Submit in Quality Control
VC Batch: Submit Individual VC in Quality Control
VC Batch: View Listings in Quality Control
InForm
Users assigned the DMW_STUDY_QC role have access to the following operations for InForm clinical data models.
Oracle LSH Object Operations
Load Set Instance: Create Execution Setup
Program Instance: Create Execution Setup
Application Area: Create Program
Program: Modify
Program: View
Program Instance: Modify
Program Instance: View
Work Area: Clone
Program Instance: Modify Validation QC
Program: Modify Validation QC
Oracle DMW Object Operations
Data Model: Load Data in QC
File Watcher
Users assigned the DMW_STUDY_QC role have access to the following operations for the File Watcher.
Oracle DMW Object Operations
Data Model: FWR ConfigurationData Model: Data Load QC
Transformations and Query Builder
Users assigned the DMW_STUDY_QC role have access to the following operations for transformations and the query builder.
Oracle LSH Object Operations
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Table Instance: Modify Val Status to QC
Table Instance: BlindBreak
Table Instance: ReadData
Table Instance: ReadUnblind
Work Area: Create Program Instance
Work Area: Create Table Instance
Work Area: Deploy (Install)
Work Area: Modify
Work Area: Modify Val Status to PROD
Work Area: Modify Val Status to QC
Oracle DMW Object Operations
Data Model: Load Data in Quality Control
Transformation Map: View
Transformation Map: Modify Validation Status QC
Transformation Map: Modify Validation Status Production
Transformation Map: Modify Supporting Info
Transformation Map: Deploy (Install) in Quality Control
Transformation Map: Modify Pvt Listing
Transformation Map: Delete Pvt Listing
Transformation Map: View Public Listing
DMW_STUDY_PROD
The DMW_STUDY_PROD role is intended for users who will work in the Production environment, including: promoting and installing clinical data models, transformations, and validation checks, loading production data from InForm and files, running transformations and validation checks on production data, reviewing data and creating custom listings, and creating and acting on discrepancies. Blinding-related privileges are also included in this role.
Users with this role should have the DMW_STUDY_MANAGER application role.
DMW_STUDY_PROD allows users to perform the following operations on the specified objects.
Clinical Data Models and Query Builder
Users assigned the DMW_STUDY_PROD role have access to the following operations for clinical data models and the query builder.
Oracle LSH Object Operations
Work Area: Create Table Instance
Work Area: Create Loadset Instance
Work Area: Modify
Work Area: Modify Val Status to QC
Work Area: Modify Val Status to PROD
Work Area: Deploy (Install)
Table Instance: Modify
Table Instance: Remove
Table Instance: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Load Set Instance: Modify
Load Set Instance: Modify Val Status to QC
Load Set Instance: Modify Val Status to PROD
Oracle DMW Object Operations
Data Model: View
Data Model: Publish Prod (used to install the Production Work Area)
Data Model: Modify Supp Info
Data Model: Modify Val Status to QC
Data Model: Modify Val Status to PROD
Data Model: Create Private Listing
Filter: Mark Filter Public PROD
Blinding
Users assigned the DMW_STUDY_PROD role have access to the following operations for blinded data.
Oracle LSH Object Operations
Table Instance: BlindBreak
Table Instance: Unblind
Table Instance: ReadUnblind
Table Instance: ReadData
Discrepancies
Users assigned the DMW_STUDY_PROD role have access to the following operations for discrepancies.
Oracle DMW Object Operations
Table Instance: Create Manual Discrepancy
Table Instance: Close Discrepancy
Table Instance: Send Discrepancy to InForm
Table Instance: Send Discrepancy to Spreadsheet
Table Instance: Reopen Discrepancy
Table Instance: Answer Discrepancy
Table Instance: Cancel Discrepancy
Table Instance: Add Comment to Discrepancy
Table Instance: Edit Discrepancy
Table Instance: Show Discrepancies
Table Instance: Create Data Amendment
Table Instance: Modify Data Amendment
Table Instance: Cancel Data Amendment
Filters
Users assigned the DMW_STUDY_PROD role have access to the following operation for filters.
Oracle DMW Object Operations
Filter: Mark as Public in Prod
Flags
Users assigned the DMW_STUDY_PROD role have access to the following operations for flags.
Oracle DMW Object Operations
Table Instance: Assign Flags
Data Lineage Tracing
Users assigned the DMW_STUDY_PROD role have access to the following operations for data lineage tracing.
Oracle DMW Object Operations
Table Instance: View CTX Data Lineage
Validation Checks
Users assigned the DMW_STUDY_PROD role have access to the following operations for validation checks.
Oracle LSH Object Operations
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Work Area: Create Program Instance
Oracle DMW Object Operations
VC Batch: View
VC Batch: Modify Validation Status QC
VC Batch: Modify Validation Status Production
VC Batch: Modify Supporting Info
VC Batch: Deploy (Install) in Production
VC Batch: Submit in Production
VC Batch: Submit Individual VC in Production
VC Batch: View Listings in Production
InForm
Users assigned the DMW_STUDY_PROD role have access to the following operations for InForm data.
Oracle LSH Object Operations
Load Set Instance: Create Execution Setup
Program Instance: Create Execution Setup
Application Area: Create Program
Program: Modify
Program Instance: Modify
Work Area: Clone
Program Instance: Modify Validation PROD
Program: Modify Validation PROD
Oracle DMW Object Operations
Data Model: Load Data in Production
File Watcher
Users assigned the DMW_STUDY_PROD role have access to the following operations for the File Watcher.
Oracle DWM Object Operations
Data Model: FWR Configuration
Data Model: Data Load PROD
Transformations and Query Builder
Users assigned the DMW_STUDY_PROD role have access to the following operations for transformations and the query builder.
Oracle LSH Object Operations
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Table Instance: Modify Val Status to QC
Table Instance: BlindBreak
Table Instance: ReadData
Table Instance: ReadUnblind
Work Area: Create Program Instance
Work Area: Create Table Instance
Work Area: Deploy (Install)
Work Area: Modify
Work Area: Modify Val Status to PROD
Work Area: Modify Val Status to QC
Oracle DMW Object Operations
Data Model: Load Data in Production
Transformation Map: View
Transformation Map: Modify Validation Status QC
Transformation Map: Modify Validation Status Production
Transformation Map: Modify Supporting Info
Transformation Map: Deploy (Install) in Production
Transformation Map: Modify Pvt Listing
Transformation Map: Delete Pvt Listing
Transformation Map: View Public Listing
DMW_STUDY_ADMIN
The DMW_STUDY_ADMIN object security role is intended for superusers. It includes the object-related roles that DMW_STUDY_DEVELOPER and DMW_STUDY_QC have, plus administrator privileges including creating studies and study categories, setting up connections to InForm and File Watcher locations, and assigning user groups to objects such as data models, transformations, and validation checks. Blinding-related privileges are also included in this role.
Users with this role should have the DMW_STUDY_MANAGER or DMW_SYS_ADMIN application role.
DMW_STUDY_ADMIN allows users to perform the following operations on the specified objects.
Clinical Data Models and Query Builder
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for clinical data models and the query builder.
Oracle LSH Object Operations
Domain: Create SubDomain
Domain: Modify
Domain: Delete
Domain: Manage Security
Domain: Create Load Set
Domain: Create Variable
Domain: Create Program
Domain: Create Data Model
Domain: Create Transformation Map
Table Instance: Manage Security
Application Area: Manage Security
Application Area: Create Work Area
Application Area: Create Program
Work Area: Manage Security
Work Area: Create Table Instance
Work Area: Create Load Set Instance
Work Area: Modify
Work Area: Modify Val Status to QC
Work Area: Modify Val Status to PROD
Work Area: Delete
Work Area: Deploy (Install)
Work Area: Create Program Instance
Variable: Modify
Variable: Modify Val Status to QC
Variable: Modify Val Status to PROD
Oracle DMW Object Operations
Data Model: Create Private Listing
Data Model: Create Public Listing
Data Model: Modify
Data Model: Delete
Data Model: Deploy (Install) Model in Dev/QC/Prod
Data Model: Modify Supporting Info
Data Model: Modify Val Status to QC
Data Model: Modify Val Status to PROD
Data Model: Create VC Batch
Data Model: Load Data in Dev/QC/Prod
Data Model: Manage Security
Data Model: Configure InForm
Data Model: Load InForm Metadata
Filter: Mark Filter Public Dev
Filter: Mark Filter Public QC
Filter: Mark Filter Public Prod
Discrepancies
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for discrepancies.
Oracle DMW Object Operations
VC Batch: Modify
VC Batch: Delete
VC Batch: View
VC Batch: Modify Validation Status Production
VC Batch: Modify Supporting Info
VC Batch: Deploy (Install) in Development/QC/Prod
VC Batch: Submit in Developmene/QC/Prod
VC Batch: Submit in Individual VC in Development/QC/Prod
VC Batch: View Listings in Development/QC/Prod
Table Instance: Create Manual Discrepancy
Table Instance: Close Discrepancy
Table Instance: Send Discrepancy to InForm
Table Instance: Send Discrepancy to Spreadsheet
Table Instance: Reopen Discrepancy
Table Instance: Answer Discrepancy
Table Instance: Cancel Discrepancy
Table Instance: Add Comment to Discrepancy
Table Instance: Edit Discrepancy
Table Instance: Show Discrepancies
Table Instance: Create Data Amendment
Table Instance: Modify Data Amendment
Table Instance: Cancel Data Amendment
Flags
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for flags.
Oracle DMW Object Operations
Table Instance: Assign Flags
Filters
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for filters.
Oracle DMW Object Operations
Filter: Mark as Public in Dev
Filter: Mark as Public in QC
Filter: Mark as Public in Prod
Data Lineage Tracing
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for data lineage tracing.
Oracle DMW Object Operations
Table Instance: View CTX Data Lineage
Validation Checks
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for validation checks.
Oracle LSH Object Operations
Program: Manage Security
Program Instance: Manage Security
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program: Modify
Program: Remove
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Program Instance: Modify
Program Instance: Remove
Execution Setup: Manage Security
Table: Manage Security
Table: View
Table: Modify
Table: Modify Val Status to PROD
Table: Modify Val Status to QC
Table: Remove
Oracle DMW Object Operations
VC Batch: Manage Security
VC Batch: Modify
VC Batch: Delete
VC Batch: View
VC Batch: Modify Validation Status Production
VC Batch: Modify Supporting Info
VC Batch: Deploy (Install) in Development/QC/Prod
VC Batch: Submit in Developmene/QC/Prod
VC Batch: Submit in Individual VC in Development/QC/Prod
VC Batch: View Listings in Development/QC/Prod
InForm
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for InForm.
Oracle LSH Object Operations
Adapter Area: Create Remote Location
Remote Location: Modify
Adapter Area: Create Web Service Location
Remote Location: View
Remote Location: Create Connection
Connection: Modify
Remote Location: Delete
Connection: Delete
Oracle DMW Object Operations
Web Service Location: Modify Web Service Location
Web Service Location: Create Connection
Web Service Location: Delete Web Service Location
Web Service Location: View
Data Model: Configure InForm
Data Model: Load InForm Metadata
File Watcher
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for the File Watcher.
Oracle DMW Object Operations
Data Model: FWR Configuration
Transformations and Query Builder
Users assigned the DMW_STUDY_ADMIN role have access to the following operations for transformations and the query builder.
Oracle LSH Object Operations
Domain: Manage Security
DataModel: Manage Security
Table Instance: Manage Security
Table Instance: Modify
Table Instance: Remove
Table Instance: Modify Val Status to QC
Table Instance: Modify Val Status to PROD
Table Instance: ReadData
Table Instance: BlindBreak
Table Instance: Unblind
Table Instance: ReadUnblind
Application Area: Manage Security
Work Area: Manage Security
Program: Manage Security
Program: Manage Security
Program: Modify Val Status to PROD
Program: Modify Val Status to QC
Program: Modify
Program: Remove
Program Instance: Modify Val Status to PROD
Program Instance: Modify Val Status to QC
Program Instance: Create Execution Setup
Program Instance: Modify
Program Instance: Remove
Execution Setup: Manage Security
VC Batch: Manage Security
Table: Manage Security
Execution Setup: Modify Val Status to PROD
Execution Setup: Modify Val Status to QC
Execution Setup: Submit
Oracle DMW Object Operations
Transformation Map: Modify Private Listing
Transformation Map: Delete Private Listing
Transformation Map: Modify Public Listing
Transformation Map: View Public Listing
Transformation Map: Delete Public Listing
Transformation Map: Manage Security for Public Listing
Transformation Map: Modify Val Stat QC for Public Listing
Transformation Map: Modify Val Stat PROD for Public Listing
Transformation Map: Modify Supporting Info
Transformation Map: Modify
Transformation Map: Delete
Transformation Map: View
Transformation Map: Modify Validation Status QC
Transformation Map: Modify Validation Status PROD
Transformation Map: Modify Supporting Info
Transformation Map: Deploy (Install) in Development/QC/PROD
Transformation Map: Modify Security
Transformation Map: Classify
DMW_STUDY_INST_ACCESS
The DMW_STUDY_INST_ACCESS role is intended for users who require only View access to data and discrepancy listings. Blinding-related privileges are also included in this role.
Users with this role should have the DMW_STUDY_CONSUMER application role.
The DMW_STUDY_INST_ACCESS role allows users to perform the following operations on the specified objects.
Clinical Data Models and Query Builder
Users assigned the DMW_STUDY_INST_ACCESS role have access to the following operations for clinical data models and the query builder.
Oracle LSH Object Operations
Domain: View
Data Model: View
Work Area: View
Table Instance: View
Blinding
Users assigned the DMW_STUDY_INST_ACCESS role have access to the following operations for blinded data.
Oracle LSH Object Operations
Table Instance: ReadData
Table Instance: BlindBreak
Table Instance: Unblind
Table Instance: ReadUnblind
Discrepancies
Users assigned the DMW_STUDY_INST_ACCESS role have access to the following operations for discrepancies.
Oracle DMW Object Operations
Table Instance: Show Discrepancies
Data Lineage Tracing
Users assigned the DMW_STUDY_INST_ACCESS role have access to the following operations for data lineage tracing.
Oracle DMW Object Operations
Table Instance: View Data Lineage Tracing
Validation Checks
Users assigned the DMW_STUDY_INST_ACCESS role have access to the following operations for validation checks.
Oracle DMW Object Operations
VC Batch: View
VC Batch: View Listings in Development
Transformations
Users assigned the DMW_STUDY_INST_ACCESS role have access to the following operations for transformations.
Oracle LSH Object Operations
Table Instance: BlindBreak
Table Instance: ReadData
Table Instance: ReadUnblind
DMW_STUDY_INFORM_CONFIG
This role has the privileges required to configure the link to InForm for an input clinical data model.
InForm
Users assigned the DMW_STUDY_INFORM_CONFIG role have access to the following operations for InForm clinical data models.
Oracle LSH Object Operations
Adapter Area: Create Remote Location
Remote Location: Modify
Adapter Area: Create Web Service Location
Remote Location: Create Connection
Connection: Modify
Oracle DMW Object Operations
Domain: Create Data Model
Data Model: InForm Config
Data Model: Modify Data Model
Data Model: Delete Data Model
