Performance Best Practice For Implementing Row-Level Security Formulas In Oracle Analytics (Doc ID 3007418.1)

Last updated on FEBRUARY 29, 2024

Applies to:

Purpose

This is part of a series of best practice articles for Oracle Analytics. It’s intended for Model Administrators who are using row-level security filters and covers row-level security which has “or logic” and uses empty values when a part of the filter is not applicable. 
Many businesses have security constraints involving different dimensions for different groups of users and for combinations of them.  The simplest implementation will apply filters for all possibilities and use an empty value for dimensions that do not apply to the specific user. 
The correct results are obtained, but the SQL contains extra tables that are not used, which can negatively impact performance.  This post explains how to get Oracle Analytics to dynamically exclude these tables.

Scope

Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.