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

Last updated on JULY 13, 2023

Applies to:

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 where you should substitute 'ABC' and 'XYZ' with your customer schema owners:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.