A resent audit of our security procedures has mandated that:
Does anyone employ these measures? if so, how?
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.
#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.