Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to find my password expiry date without asking the DBA?

My user does not have privileges to view the DBA_USERS table. Also, I tried select * from USER_USERS table, but expiry_date is empty.

share|improve this question

3 Answers 3

up vote 6 down vote accepted

It might be that your account has been assigned the profile with PASSWORD_LIFE_TIME set to UNLIMITED, and thus your password will never expire. You can query the USER_PASSWORD_LIMITS view to determine what password limits are currently in effect for your account:

SQL> select * from user_password_limits;

RESOURCE_NAME                    LIMIT
-------------------------------- ---------
PASSWORD_LOCK_TIME               1
PASSWORD_GRACE_TIME              7
share|improve this answer
select username, account_status, expiry_date from user_users;

works for me.

share|improve this answer
This answer is also correct. Why does it get down-voted? NULL=Unlimited and any other date shows the expiry date. –  ora-600 Jan 8 at 12:57

Issue this command:

select username, account_status, expiry_date, profile from dba_users;
share|improve this answer
The question states: "My user does not have privileges to view the DBA_USERS table". –  Jon Seigel Nov 21 '13 at 18:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.