Archives of the TeradataForum

Message Posted: Thu, 18 Mar 2004 @ 13:34:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, March 18, 2004 08:32 -->

Yes, there are two ways of doing this.

First - Embed a common userid/password in the catalog or the odbc connection thereby not requiring a userid/password. However, note that using this method that all users will use the same userid/password and therefore any database security will not be in effect. Also note that shared temporary space may be at risk if you have a large number of users running a SQL query at the exact same time.

Second - Using Cognos Access Manager you can setup userid/passwords for all of your users (as appropriate) and then when the user drill's through to the report it will pass the userid/password for them. This solution ensure database security is respected and that the temporary table spaces are more optimally managed.

	<Prev	Next>		<<First	<Prev	Next>	Last>>