oracle password aging

[Michael Murphy_2]

Folks - does anyone know of a command in oracle that will report a list of users whose id will expire in x number of days (either a command line command or sql?) Thanks...

[Peter Godron · Accepted solution]

Michael,
first of all the expiry_date has to be set!

Then use SOMETHING LIKE:
select username,expiry_date from dba_users where to_date(nvl(expiry_date,sysdate)) < sysdate + 10;

Regards

[Jean-Luc Oudart]

These users will expire depending on their profile.

select username,profile, expiry_date
from dba_users
where expiry_date is not null
and expiry_date < sysdate + x

Regards
Jean-Luc

[Michael Murphy_2]

Perfect solutions...Thanks