This content has been marked as final. Show 9 replies
Follow the link
if you stillhave problem then ping back.
Mark if helps,
That links talks about 10g version.
Step1: We have imported a secutiry table in Physical layer.
Step2: Creating a session variable by selecting initilazation block.
Select user_name,group from security_table where user_id=':USER' and pwd=':password';
step3: created DISPLAYNAME,GROUP & USER VARIABLES in edit target window
After these modifications i was trying to logging with new user, which is there in security table.
I am getting an error that is invalid user or password.
Is there any other changes does it required here.
Edited by: user10675696 on Dec 26, 2012 9:39 PM
Link talks about 11g version itself.
Try creating only USER and DISPLAYNAME in the same order and check.
mark if helps,
I have created the variables in same order, but getting an error.
I have a security table, which contains userid,displayname,group . I have imported Security table in Physical Layer. I'm creating session variables based on condition.
When am trying to logging into analytic s getting an error, invalid username and password . I'm using 220.127.116.11.0 version
How to handle external table authentication in OBIEE 11g version.
Check for the spaces in the column or cases ur entering all those things.
Better to user trim function in query block.
Do some dry checks.
I have checked everything. Getting same error.
An invalid User Name or Password was entered
Do we need to add any roles ,group in console?
Any Solutions Plz?
Are you using Plaintext password or encrypted password?
If you are using encrypted then try the below code in INIT Block.
select username, groupname, from users