BI report cannot be restricted with data access set — Oracle Analytics

Oracle Analytics Publisher

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

BI report cannot be restricted with data access set

Accepted answer
33
Views
2
Comments
Jimin Park
Jimin Park Rank 1 - Community Starter
edited Jun 5, 2024 6:59AM in Oracle Analytics Publisher

Hello,

A user without a data access set(where only ledger A is attached) is able to select ledger A as the report's parameter, and view its data as well.

(the user is not attached to the BU, and does not have access to the ledger on GL page)

I have checked the FUN_USER_ROLE_DATA_ASGNMNTS ROLE table, and found a row where this user's GUID was attached to ledger A's access_set_id.

What should I do to not let this user have access to ledger A on BIP?

Tagged:

Best Answer

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @John Hung-Oracle - Please assist in moving this thread to OTBI community the table and access related query mentioned is from Fusion schema. They will be able to guide appropriately. Thanks.