Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

Fight of co-existance :: Application Role (OBIEE 11g) and Groups (OBIEE 10g)

Posted by sranka on April 22, 2011

Hi All

Past few I have been implementing OBIEE 11g with BW SAP backend/data source. The journey wasn’t easy and challenges are still not over. But during 10g upgrade, I came across an interesting situation where I had to design security for 11g OBIEE but support 10g security from upgrade in the same rpd and webcatalogue

As we all are aware 10g requires GROUPS (data/object level security) and WEBGROUPS (Webcatalogue level object security) for security. Due to backward compatibility GROUPS and WEBGROUPS are present in 11g as well.

Interesting Observation :

When you set ROLES and GROUPS session variable, ROLES takes precedence over GROUPS and only ROLES values are present, when you click on My Account –> Roles and Group. This could be potential oracle bug, but in my case we reverted back to 10g security where we are continuing to use GROUPS and WEBGROUPS variable.

Hope This Helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

Advertisements

One Response to “Fight of co-existance :: Application Role (OBIEE 11g) and Groups (OBIEE 10g)”

  1. Rishikesh said

    Hi Sunil,

    I have a following question. Can you please help me to get the answer ?

    1. Typical Risk of upgrading to OBIEE 11g
    2. Typical issues faced in upgrading to OBIEE 11g

    Please email me the answers at rishikesh75@gmail.com

    Thanks,
    Rishikesh

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: