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.
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
