Archives of the TeradataForum

Message Posted: Fri, 14 May 2004 @ 13:52:56 GMT

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

You have to have DBC.SYSSECDEFAULTS setup to expire passwords at some interval (UPDATE DBC.SYSSECDEFAULTS SET PASSWORDEXPIRE = 90 /* number of days between expirations */ - also takes a TPARESET to recognize the change)

Then you can issue the following command:

MODIFY USER USERNAME AS PASSWORD = mytemppassword FOR USER;

The FOR USER clause expires the password immediately and forces the user to enter a new password at the next logon.

Kyle Prescott
Teradata Certified Professional
UnumProvident - Data Strategies, 3-South

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