Archives of the TeradataForum
Message Posted: Fri, 14 May 2004 @ 13:52:56 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|