Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Temporary Password
 
From:   Prescott, Kyle R

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023