Archives of the TeradataForum

Message Posted: Wed, 03 Nov 2004 @ 15:33:18 GMT

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

Yes, your SQL Assistant account is your Teradata ID, they are one in the same. Another way your users could change it is through SQL via the command:

     Modify user username as password = user_password;

That and SQL Assistant are the only end user methods I know available. Obviously that doesn't work for your Cognos users if they don't have any ODBC interface to Teradata. What I do for Cognos users is create all their individual IDs with a DBA assigned password. This password is set to never expire. Then our Cognos developer creates a "sign-on" in Cognos for these users and assigns that to their Cognos application IDs.

Since the end user never knows their Teradata ID/password, and it is stored encrypted in Cognos, it complies with our password policy for unexpiring IDs. The key here is keeping the Cognos ID separate from the Teradata ID. The only other option would be for our Cognos developer to have to go through and update the "sign-on's" should the Teradata passwords have to change. Crystal clear, right?

--Jason

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