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.
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
