Sunil S. Ranka's Weblog

Superior Data Analytics is the antidote to Business Failure

Row-wise initialization block for ROLES session variable doesnt set any value

Posted by sranka on March 25, 2011

Hi All

Its been while since I posted some thing on OBIEE, Cricket World cup was keeping me busy with new opportunity and options took most of my time. Recently I started reviewing current security requirements at a new client. While doing implementation I came across very starnage thing that my ‘ROLE’ session variable was not getting initialized. After doing research and talking with Oracle it was confirmed that its a bug on Oracle Side. Follwing are the details :

Roles are set using ROW WISE initialization:

1) SQL> select ‘ROLES’,rolename from groups where username=’user1′;

ROLES                    ROLENAME
—————             ———————————————
ROLES                    role1
ROLES                    BIAdministrator
ROLES                    AuthenticatedUser

2) Login failed.

A bug has been logged and should be fixed in 11.1.1.4 .

Work Around
But for now the recommended workaround is NOT to use the row-wise initialization block for ROLES session variable. You will need to use regular initialization block to solve the problem.

Hope This Helps,

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

Advertisements

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: