cancel
Showing results for 
Search instead for 
Did you mean: 

oracle password aging

SOLVED
Go to solution
Michael Murphy_2
Frequent Advisor

oracle password aging

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...
3 REPLIES
Peter Godron
Honored Contributor
Solution

Re: oracle password aging

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
Honored Contributor

Re: oracle password aging

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
fiat lux
Michael Murphy_2
Frequent Advisor

Re: oracle password aging

Perfect solutions...Thanks