OAC BI publisher security setup

VijayDC

Hi All,
We have a Oracle DB schema with sensitive data, we are planning to create BIP reports and publish them on classic dashboard,
for this schema we are not creating any SA in RPD or semantic model,

we are planning to create couple of data models and create reports on top of them.

we need to setup Data level security for BI Publisher reports.

I got this link Microsoft Word - wp-oracle-bip-row_level_security.doc

but we want to know different approaches available to setup RLS for BIP Reports.

TIA

Sumanth V -Oracle

@VijayDC - We can explore the following options to implement row-level security in the BI Publisher data model:

1. Parameter-Based Security in the Data Model

• Approach:
  • Create a user-based parameter (e.g., P_USER) in the BI Publisher data model.
  • sqlCopyEditWHERE USER_ID = :P_USER
  • Use BI Publisher’s built-in variable XDO_USER_NAME to dynamically retrieve the logged-in user's name and pass it as the parameter value.

2. Apply Filters in the Data Model SQL

• Approach:
  • sqlCopyEditSELECT * FROM SALES_DATA WHERE REGION IN ( SELECT REGION FROM USER_SECURITY WHERE USERNAME = :XDO_USER_NAME)
  • The XDO_USER_NAME variable dynamically passes the logged-in BI Publisher user's username to the query, ensuring user-specific data access.

Hope this helps!