I want to give access on table level to developers as want to restrict the sensitive or salary related data Also they should not be able to see the data in table even in Data model using select query Eg: select * from "Salary_tb"
Hi Anuksha
Please review the given documentation link and use the secured tables
Doc ID 1537196.1 Fusion Apps - How Can A BI Publisher Report Based On A SQL Query Use The Security Roles In Fusion Applications?
Hi @AnushkaUrunkar,
Welcome to the Oracle Analytics Community!
It seems it is not possible to restrict BI Publisher Data Models to specific tables.
Please check the following Oracle Note:
https://support.oracle.com/knowledge/Oracle%20Cloud/2819026_1.html
Hope this help.
Thank you.
When we do untitled DM will this solution work for that as well?
Our problem is like live data is in PROD and we have dedicated team to support the PROD related issues.
Now we want to minimize the team work so that dev team can debug there issues on there own only they should not be able to access the PII data and salary related data.
Ideally you need to do the Data Masking in your non-prod environment so that developers will not be able to see the sensitive real data.
Here's a good read which can provide more information.
https://docs.oracle.com/en-us/iaas/Content/fusion-applications/manage-security-data-masking.htm
But we have live data on PROD itself not always we can produce the issues on non-prod environment
It is not possible to restrict BI Publisher Data Models to specific tables.
Here are some ideas in the idea lab requesting that feature. I'll recommend to go through those and upvote, comment so that Oracle might consider these in future release.
GSI - Data Source Access across Oracle Pillars (HCM and FIN) - BI Admin — Oracle Analytics
Restrict BIP access (table access) for person, sensitive data — Oracle Analytics
Hope this clarify.
Your problem isn't about restricting the tables or tables content somebody can access in a Publisher data model, because that can easily be managed with common database security (as you talk about tables I assume a database to be involved).
Your problem is more about Fusion not giving you the required granularity in the security for your needs.
If it's only about Fusion, then it isn't really a Publisher issue, it's an implementation choice of how Fusion decided to implement security and use various products, like Publisher. If this is the case, then you should try to discuss and report your issues in the forum covering Fusion products: https://community.oracle.com/customerconnect
Publisher will just enforce whatever security is implemented based on the credentials used to connect to the source. If those credentials have access to too many tables or content, then Publisher can't do anything for it, also because it isn't its role: it does just respect whatever security has been used and whatever credential has been defined in Publisher.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Hi , We are developing a BI Publisher report to retrieve only Learning Initiatives. We are currently using: WLF_EVENT_ASSIGNMENTS_F WLF_EVENT_ASSIGNMENTS_F_TL WLF_ALL_LEARNING_ITEMS_V WLF_ASSIGNMENT_DESTINATIONS_F We are filtering EVENT_TYPE = 'ORA_REQUIRE_ASSIGNMENT'; however, the results also include other assignment…
Hi Experts, I have a report with simple SQL but large output (140M). Its output file was ,xlsx base on an rtf templete. It always takes time to run. May I know is there any good way to reduce the ruing time of it ? Thanks in advence! Weutao
I have been tasked with creating a run book for ESS jobs. Whilst the queries are centred on the ESS_REQUEST_HISTORY table I would appreciate any suggestions/best practice for implementing a set of reports
Hi,😊 I have a technical issue that I am struggling to resolve. I created an RTF layout, and the preview works correctly when using the BI Publisher Add-in tool. However, when I upload the layout in eText format, the generated report displays only question marks (???) instead of the expected data. I have not been able to…
hi Oracle team, Have a scenario: Country = A, then page 1 should have a notification for that country with no header/footer however page 2 onwards, the existing content with header/footer. but if Country != A then no notification and has to display existing one with the header/footer. Tried option A: Native word option…
