Archives of the TeradataForum
Message Posted: Thu, 18 Mar 2004 @ 13:34:40 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|