Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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