6

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.

9

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
-------------------------------- ---------
FAILED_LOGIN_ATTEMPTS            10
PASSWORD_LIFE_TIME               UNLIMITED
PASSWORD_REUSE_TIME              UNLIMITED
PASSWORD_REUSE_MAX               UNLIMITED
PASSWORD_VERIFY_FUNCTION         NULL
PASSWORD_LOCK_TIME               1
PASSWORD_GRACE_TIME              7
| improve this answer | |
1
select username, account_status, expiry_date from user_users;

works for me. Caveat: this works only for the user you are logged on as.

| improve this answer | |
0

You need elevated privileges to view DBA_USERS - that's if you can't select from DBA_USERS. Get help from a DBA or use an account with the required privileges.

| improve this answer | |
-3

Issue this command:

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

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