Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

There is a way to limit access to specify tables trought customize DM in OTBI?

Accepted answer
12
Views
1
Comments
Yael Medina
Yael Medina Rank 1 - Community Starter
in Oracle Analytics Publisher

Hi everyone!

We have a requeriment, and we need to know if there is a way to restrict the access an specifics tables in oracle fusion trought customize DMs in OTBI? I mean, create a custom role with access to OTBI and just can query the following tables and not others.

FND_FLEX_VALUES

FND_FLEX_VALUES_TL

FND_FLEX_VALUES_VL_DM

FND_ID_FLEX_SEGMENTS

FND_SEGMENT_ATTRIBUTE_VALUES

FND_USER

GL_BALANCES

GL_BALANCES_PERIOD 

GL_CODE_COMBINATIONS

GL_JE_BATCHES

GL_JE_HEADERS

GL_JE_LINES

GL_JE_SOURCES_B

GL_LEDGER_LE

GL_LEDGERS

GL_PERIODS

HRW_LEGAL_ENTITIES_DM

HZ_CUST_ACCOUNTS_DM

HZ_PARTIES_DM

DM_VENDOR

ORA_AP_GL_VENDOR_LISTING_DM

PER_ALL_PEOPLE_F

PER_PERSON_NAMES_F

PER_USERS

POZ_SUPPLIERS

Tagged:

Best Answer

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist
    Answer ✓

    Hi @Yael Medina ,

    As per my knowledge, this is not supported currently. Once you have access to query one table, you can query all other tables as well. There are certain set of tables from HCM( which I am aware of) that hold PII information will retrieve data only with certain access but not all the tables.

    Thanks.