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

Question

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

MandeepGupta · Accepted 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.