Request For Read Only Access On Views/Tables From CDR And Apps Schemas (Doc ID 2288294.1)

Last updated on OCTOBER 30, 2017

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.6 and later
Information in this document applies to any platform.

Goal

Request for read only access on Views/Tables from CDR and APPS Schemas.

DMW users requested read only access on CDR and APPS views for debugging purpose. The plan is to create a new Database Role for read-only permission, grant select on below table/views to this role and then assign this role a DMW user’s Database account. Below is a list based on frequently used table/views and Public views listed in LSW manuals.

1. To find out owners of the database objects, use this query:

2. The output is as follows:

CDR.CDR_BA_SCHEMA_ACCESS
CDR.DME_MAP_ENTITY
CDR.DME_XFORM_MAP
CDR.DME_STATIC_PKGS
CDR.CDR_JOBS
CDR.DME_DISCREPANCIES
CDR.DME_DISC_ACTIONS
CDR.CDR_DATA_MODEL_DEPL_VERS
CDR.DME_XFORM_EXPRESSION_ITEM
CDR.CDR_BA_DB_PRIVILEGES
CDR.CDR_SECURITY_DBACCOUNT
CDR.CDR_TABLES

APPS.DME_DF_MAP_ENTITY_V
APPS.DME_SCHEDULED_JOBS_V
APPS.DME_STUDY_TABLES_V
APPS.CDR_TABLE_REF_JOBS
APPS.FND_USER
APPS.CDR_NAMING_VERSIONS
APPS.DME_PUB_TABLES_V
APPS.DME_PUB_DATAMODEL_V
APPS.DME_STUDY_TABLES_V
APPS.CDR_NAMINGS
APPS.DME_SEND_DISC_TO_INF_QTB
APPS.DME_DISCREPANCIES
APPS.DME_DISC_ACTION_HISTORY
APPS.DME_MAP_ENTITY
APPS.DME_XFM_TARGET_COLUMNS_V
APPS.DME_STUDY_V
APPS.DME_XFORM_MAP
APPS.CDR_PROGRAM_REFS
APPS.DME_XFORM_MAP_DEPL_VERS
APPS.CDR_BA_DB_PRIVILEGES
APPS.CDR_DF_NAMING_V
APPS.CDR_DF_SRCCODES_V
APPS.CDR_LOOKUPS
APPS.CDR_PUB_GENERIC_BA_V
APPS.CDR_SECURITY_DBACCOUNT
APPS.CDR_TABLES
APPS.DME_COLUMNS_V
APPS.DME_CONSTRAINT_COLS_V
APPS.DME_CONSTRAINT_V
APPS.DME_DATAMODEL_V
APPS.DME_LOV_VALUES_V
APPS.DME_PUB_CODELIST_V
APPS.DME_PUB_CODELIST_VALUES_V
APPS.DME_PUB_COLUMNS_V
APPS.DME_PUB_DF_MAP_ENTITY_V
APPS.DME_PUB_DF_XFORM_MAP_V
APPS.DME_PUB_DISCREPANCIES_V
APPS.DME_PUB_VC_BATCHES_V
APPS.DME_PUB_VC_DETAILS_V
APPS.DME_PUB_XFM_AUTOMAPS_V
APPS.DME_PUB_XFM_COL_AUTOMAPS_V
APPS.DME_PUB_XFM_CUSTOM_PROGRAMS_V
APPS.DME_PUB_XFM_EXPR_STATIC_PKGS_V
APPS.DME_PUB_XFM_EXPR_STDFUNC_V
APPS.DME_PUB_XFM_SOURCE_COLUMNS_V
APPS.DME_PUB_XFM_SOURCE_TABLES_V
APPS.DME_PUB_XFM_TARGET_COLUMNS_V
APPS.DME_PUB_XFM_TARGET_TABLES_V
APPS.DME_SDTM_COL_IDENTIFIERS_V
APPS.DME_SDTM_TAB_IDENTIFIERS_V
APPS.DME_TABLES_V

PUBLIC.CDR_BA_DB_PRIVILEGES
PUBLIC.CDR_DF_NAMING_V
PUBLIC.CDR_DF_SRCCODES_V
PUBLIC.CDR_LOOKUPS
PUBLIC.CDR_PUB_GENERIC_BA_V
PUBLIC.CDR_SECURITY_DBACCOUNT
PUBLIC.CDR_TABLES
PUBLIC.DME_PUB_CODELIST_V
PUBLIC.DME_PUB_CODELIST_VALUES_V
PUBLIC.DME_PUB_COLUMNS_V
PUBLIC.DME_PUB_DF_MAP_ENTITY_V
PUBLIC.DME_PUB_DF_XFORM_MAP_V
PUBLIC.DME_PUB_DISCREPANCIES_V
PUBLIC.DME_PUB_VC_BATCHES_V
PUBLIC.DME_PUB_VC_DETAILS_V
PUBLIC.DME_PUB_XFM_AUTOMAPS_V
PUBLIC.DME_PUB_XFM_COL_AUTOMAPS_V
PUBLIC.DME_PUB_XFM_CUSTOM_PROGRAMS_V
PUBLIC.DME_PUB_XFM_EXPR_STATIC_PKGS_V
PUBLIC.DME_PUB_XFM_EXPR_STDFUNC_V
PUBLIC.DME_PUB_XFM_SOURCE_COLUMNS_V
PUBLIC.DME_PUB_XFM_SOURCE_TABLES_V
PUBLIC.DME_PUB_XFM_TARGET_COLUMNS_V
PUBLIC.DME_PUB_XFM_TARGET_TABLES_V

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms