Hi, We are currently using Oracle Analytics Cloud (OAC) with Autonomous Data Warehouse (ADW) and loading data from our on-premises Oracle Database to ADW using Oracle Data Integrator. In Oracle E-Business Suite (R12), we filter data based on operating units by leveraging responsibilities. Could you please guide us on how to implement a similar row-level security (RLS) mechanism in ADW to filter data dynamically based on the logged-in user? Specifically, we would like to understand: How to pass the logged-in user's information from OAC to ADW. Best practices for filtering data at the row level using session variables or other methods in ADW. Thanks, Jay

@Jaykumar Perumal Please refer the below official documentation. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/work-row-level-security.html

Hi @Jayakumar Perumal How about Building Semantic Models in Oracle Analytics Cloud since you are using OAC Enterprise version now? Thanks Harriet

Oracle Analytics Forum

Implementing Row-Level Security in Oracle Analytics Cloud with ADW

Accepted answer

202

Views

Comments

Answers

GayathriAnand-Oracle Mod

Aug 27, 2025 6:36PM

Please check https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/work-row-level-security.html

0

Oracle Analytics Forum

Categories

Implementing Row-Level Security in Oracle Analytics Cloud with ADW

Answers