Hi,
Is there a way to apply data level/row level security in Oracle analytics server. Can someone help with the steps.
Thanks in advance!!
Thanks,
Satya
To conclude and summarize this thread. When Enabling row-levels security filters with OAS in the semantic layer (repository/RPD), the filters do not apply the the BIServiceAdminstrator role. This is only related to the "weblogic" user because you have assigned that specific user the BIServiceAdministator role explicitly, or implicitly (via groups).
You can implement and enforce row-level data security in both the repository and in the database, if you need. In your case, you can also remove the role from the user (in OAS 2024, you can use fine grain permissions if necessary)
Resources
About Data Filters and Row-Level Security https://blogs.oracle.com/analytics/post/best-practices-for-implementing-rowlevel-security-in-oracle-analytics-1
@satya_nvs - Applying data-level security to the WebLogic or admin user is not recommended. Here’s why:
Therefore, it's best to avoid applying data-level security to the WebLogic or admin user and instead focus on properly managing privileges for operational roles.
Hi @Sumanth V -Oracle i totally agree with your points. But we have got a requirement for couple of our HR reports to apply the data security for weblogic as the weblogic password is available with the core development and prod support team.
Just wanted to check if the datalevel security can be applied to weblogic only for those reports or not.
Thanks for your suggestions.
@satya_nvs It is not possible as the user 'weblogic' has BI Administrator application role.
