Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data and Dashboard Security using ROLES Variable in OBIEE 11g

649804Nov 3 2011 — edited Nov 14 2011
Hi all,

I'm currently using OBIEE 11g. I'm wondering how to implement the security for data and dashboard in the 11g.

Below is the sample of how the security matrix requirement when I use the 10g version. In 10g, we usually use GROUP (for the data filter in RPD) and WEBGROUPS (for dashboard objects) variables in my initialization block to read from database. As we have 2 different variables, it is possible to control security separately for data and dashboard.

GROUP | Country
----------------------
G1 | US
G2 | FR
G3 | UK

WEBGROUPS | Dashboard
-----------------------------------
WG1 | D1
WG2 | D1
WG3 | D1
WG1 | D2
WG2 | D2
WG1 | D3
WG3 | D3
WG3 | D4

Now, in 11g, the recommendation is to use ROLES variable (for application role). So, how would I apply the required security matrix above in 11g using just ROLES variable? Do I still create G1, G2, G3, WG1, WG2, and WG3 as application roles then only use G1-3 in the RPD to filter the data and only use WG1-3 in the analytics to serve as webgroups?

Any advice on this? Thank you very much.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 12 2011
Added on Nov 3 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
4 comments
580 views