Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 Jan 2005 @ 20:47:02 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Password change for first time users
From:   Dempsey, Mike

Use the "FOR USER" clause of the Modify User statement.


     MODIFY USER xxx PASSWORD = atemppwd FOR USER;

I dont think this clause is supported on the Create User statement (not sure why not) so if this is a new user you would have to first create it, then modify it. (I think this feature was introduced in 5.0 ... but it MAY exist in an earlier release.)

If you use Teradata Administrator you would simply check the 'Temporary' checkbox to the right of the Password textbox. (Introduced in TDAdmin 6.1)

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023