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


  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***


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

     .logon mynewsystem/user1
      *** 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,


  <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: 23 Jun 2019