Query to check when my Oracle Password Expires


Below query will display the info about the users there account status and expiry date of password:

 col USERNAME for a20;
 col EXPIRY_DATE for a20;
 set line 300;
 select username,ACCOUNT_STATUS,EXPIRY_DATE from dba_users;
Please share If you like..Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Yummly


Add a Comment
  1. Good information like it….

Leave a Reply

Your email address will not be published. Required fields are marked *

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA
Go Back