Best Practices For Implementing Row-Level Security In Oracle Analytics
Associated with
Best Practices For Implementing Row-Level Security In Oracle Analytics

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.

More Ways to Read:
🧃 Juice It The key takeaways that can be read in under a minute
Sign up to unlock