Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 May 2004 @ 15:55:53 GMT


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


Subj:   Re: Temporary Password
 
From:   Lim, HockHooi

Question:

  How do I create a new user with a temporary password? I mean temporary in that Teradata will prompt the user for a new password on their first login.  


  The CREATE/MODIFY USER syntax diagram doesn't seem to allow any option to make a temp password....  



My 2 Cents:

If you do not want to enable a system-wide password reset option or need to keep the system up, do this,

--Create a profile

create profile htest as password = (expire=1);


--assign existing user to that profile

modify user user1 as profile=htest;


--modify the user's password, note the for user keyword

modify user user1 as password=whatever for user;


You will see these lines next time if you sign in as user1:

     ***dos bteq***

     I:\>bteq

      Teradata BTEQ 08.02.00.00 for WIN32.
      Copyright 1984-2002, NCR Corporation. ALL RIGHTS RESERVED.
      Enter your logon or BTEQ command:
     .logon mynewsystem/user1

     .logon mynewsystem/user1
     Password:
      *** Warning 3032 USER PASSWORD HAS EXPIRED.
     Enter new password:
     Again, please:

      *** Logon successfully completed.
      *** Transaction Semantics are BTET.
      *** Character Set Name is 'ASCII'.

      *** Total elapsed time was 10 seconds.

     ***end dos bteq ****

Thank you,

Hock



     
  <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: 27 Dec 2016