SQL DTS to Check for TERADATA password expiry

By kaypaul ·
How can I check for the TERADATA password expiry 1 week before expiring via SQL DTS?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Query to check Password Expriy

by khalidrehman83 In reply to SQL DTS to Check for TERA ...

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;

Related Discussions

Related Forums