If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Oracle: Signon by An external namespace

Started by Point, 20 Dec 2013 02:57:14 AM

Previous topic - Next topic

Point

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,

navissar

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