prompt user before password expires

Database
Fan

prompt user before password expires

A resent audit of our security procedures has mandated that:

  1. users are prompted 5 to 14 days in advance of their password expiring.
  2. a minimum password age be configured. For example, you can only change your password once in a 24-hour period.

 Does anyone employ these measures? if so, how?

 

3 REPLIES
Teradata Employee

Re: prompt user before password expires

The Teradata database does not support these particular password controls. Directory-based authentication (where passwords are managed outside the database) may help address this requirement.

Highlighted
Junior Contributor

Re: prompt user before password expires

#1 can be done by joining dbc.UsersV and dbc.ProfileInfoV, calculating the number of days until the password expires based on PasswordLastModDate and ExpirePassword and sending a mail to those users.

 

Fan

Re: prompt user before password expires

Thanks for responsing. 

I will present your answers to our nternal auditor for feedback/approval.

thanks again!!