Archives of the TeradataForum

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

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

Question:

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