Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Jun 2003 @ 13:51:44 GMT

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

Subj:   Re: Password Expiration and NULL PASSWORD
From:   Dempsey, Mike

I would be wary of allowing 'WITH NULL PASSWORD' for too many user ids.

If you are using V2R5.0 you can assign the users to a profile (or more than 1 profile) and use the password properties of the profile to prevent expiration of the password for users in these profiles. The passwords do not have to be null in this case.

Teradata Administrator 6.1 will allow you to set the password properties of the profiles (due out near end of year). Unfortunately no one mentioned the feature to me until it was too late to include it in version 6.0, so until then you will have to simply update the dbc.profileinfo view manually.

Mike Dempsey
Teradata Client Tools

  <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