Forum Stats

  • 3,839,777 Users
  • 2,262,536 Discussions
  • 7,901,054 Comments

Discussions

Retriving a cookie variable in a init block

Hello
I configured obiee for sso.

Here is my instance config:
<Auth>
<SSO enabled="false">
<ParamList>
<!--IMPERSONATE param is used to get the authenticated user's username and is required -->
<Param name="IMPERSONATE" source="cookie" nameInSource="SSOUSERNAME"/>
<Param name="NQ_SESSION.TICKETID" source="cookie" nameInSource="TICKETID"/>
</ParamList>
</SSO>
</Auth>


Here is my init block in the repository
SELECT ':USER' FROM dual where obiee_auth_api.validate_and_expire_ticket(':USER', ':NQ_SESSION.TICKETID') = 'Y'

When I run that, I dont get logged in.
If I replaced ':NQ_SESSION.TICKETID' by a hard-coded ticket id like 'xxx-xxx-xxx-xxx' it works and I'm logged in.

So I guess I'm not retrieving the variable value correctly.

Does someone know how to do that?

Thanks
Tagged:

Answers

This discussion has been closed.