Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Provide Innovation Management Security Views to support role based data access within custom query B
Lowell Stang
Rank 2 - Community Beginner
Organization Name
Williams
Description
Customer needs the ability to support role based data access with BI Publisher reports that contain custom SQL queries. This is usually provided through special security access tables that are joined to the custom reporting SQL. Should behave similarly to MOAC security views for Financials.
Use Case and Business Need
OTBI is incapable of supporting the customer's reporting needs, but would enforce role based data access. To satisfy the reporting requirements, custom BI Publisher reports with custom data model SQL were developed - when leveraging this approach, role based data security is not enforced. Some information maintained in Innovation Manage is considered sensitive and needs to be protected within reporting.
Original Idea Number: 0924ae6828
2