Hi all,
I have the following problem:
For my sources DB2 and Netezza i am using the signon function to the DB with an external namespace.
On that way when a report is run it is done by the users account to access the DB. An additional DB security sow only users that have access to the report and the DB can run the report with Data.
I also want to implement this function with my Oracle Source, But when adding the Oracle source you dont have the "standard" function to select signon by external namespace.
Only by hard coded user/password.
I think i should be possible only then by the additional CommandBlocks, but the documentation about this is not very clear.
Do's anybody done this before or know where to find some better documentation about this option.
Kind regards,
Hey,
You're about to enter the exciting world of Oracle Single Sign On via IBM Cognos. I've done it once, and it was a great learning experience.
You should probably have an Oracle DBA with you for the process.
In general lines: In order to allow Oracle SSO, most commonly you would use a proxy user. You'll have the connection set up to login as the proxy user, and use an XML function to pass the current user's login data to the Oracle, so proxy user gets your user's permissions.
Dig in a bit further here:
http://www.ibm.com/developerworks/data/library/cognos/page458.html