Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Impose security that segregates data by BU in lower environments for report development

Organization Name
PriceWaterhouseCoopers
Description
Impose security that segregates data by BU in lower environments for report development
Use Case and Business Need
In the case of access for territory "Reporting champions" in order to develop local reports in Oracle. Idea was to provide access to “OTBI reporting areas” which should be limited via BU data access for the particular territory. This would solve data segmentation problems and local reporting champions would have access only to the territory they belong to. While the definition of this new role was being analysed from a security perspective, system limitations were found and confirmed by Oracle, meaning that the current security model isn’t broken down into much needed degree of granularity (we would need report writing to be segregated with the ability to construct a DM invoking SQL data access). . That means providing access for territory champions means that they would have access to whole data in the system - each territory data that is onboarded to Oracle EMFI program
Original Idea Number: 659e13456a