Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 11 Aug 2000 @ 14:56:15 GMT

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

Subj:   Re: Selective Password Expiration
From:   David Wellman


David (Roth) is correct in that you shouldn't go around amending system tables. I've seen it done in production scripts and it generally works, but bear in mind that NCR do NOT support such actions (and I think that's a reasonable stance to take).

Assuming that the passwords that you want to be non-expiring are for batch id's etc (and therefore you know what you want the passwords to be), then it's a fairly simple task to write a Bteq script which generates the necessary "MODIFY USER ..." commands to ensure that the password for those userid's never expire.

But, it would be nice if Teradata did it for 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: 15 Jun 2023