Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 82 Oracle Analytics Trainings
- 15 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
Fusion Cloud BI How can we setup security on GL tables query In BI Publisher Datamodel

Jaswanth Elite
Rank 4 - Community Specialist
Summary
Fusion Cloud BI How can we setup security on GL tables query In BI Publisher Datamodel
Content
we setup security on GL tables query In BI Publisher Data model
I am using GL_JE_lines table query
i want to setup security in data model (i.e) if we have 3000 Dept and manager of that department is Philip then he can only see his data not by other managers
0
Answers
-
You need to get the users information to the query. In the standalone BIP version the user and their role are available to the data model and the layout template.
Once you have that information you can do a lookup in the queries to limit the rows returned by the report.
Check out row level security with BI Publisher paper
Tim
1