Software

Ask something
Question Locked

SQL DTS to Check for TERADATA password expiry

0 helpful
2 replies

by paulkayengheng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How can I check for the TERADATA password expiry 1 week before expiring via SQL DTS?

2 replies

by khalidrehman83

Though it's too late, but i got it now...

Select a.username,a.PAsswordLastmoddate

where a.ownername = 'DBA_USER'

and a.PasswordLastModDate +b.ExpirePassword >= date - 7

from dbc.users a, dbc.SysSecDefaults b;

This discussion is closed to new replies.