COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: kado on 13 Jan 2010 12:55:31 PM

Title: 1 package, 2 groups, different DB logins
Post by: kado on 13 Jan 2010 12:55:31 PM
Hello,

I have 2 user groups that I would like to have access to the same Framework Manager package but with different logins for each. Within Framework Manager I can set up 2 different logins (to the same data source) under 'Data Sources' but then am confused how I associate these seperate logins to each group. I assume I could use a Parameter Map (and set up the 'Key' and 'Value') but then am still not sure how to assign one to one group and then another to the other group.

Any suggestions? thoughts? advice?
thanks,
mcaton
Title: Re: 1 package, 2 groups, different DB logins
Post by: MFGF on 14 Jan 2010 03:25:19 AM
Hi,

Advanced options like this are not available from within Framework Manager - all you get is a simplified wizard interface to set up a Cognos 8 data source, and this allows only a single signon (for everyone) to be defined in the connection.

You need to use a browser to log in to the Cognos 8 server (as an administrative user) then Launch -> IBM Administration Console.  Select the Configuration tab at the top, and your data sources should be visible.  For the data source in question, first click on the name to drill into it, then click again on the name of the connection to get to a view of the signons.  You can then use the button at the top to add your new signons (one at a time), and go to the Permissions tab in each and grant access only to the required group.  Finally, edit the original signon and change the 'everyone' permissions to omit the two groups used in the other signons.

Hope that helps!

MF.
Title: Re: 1 package, 2 groups, different DB logins
Post by: kado on 19 Jan 2010 03:31:00 PM
That does help, THANKS MF!!!