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
Fusion Cloud BI How can we setup security on GL tables query In BI Publisher Datamodel

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
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