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.
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
select username, account_status, expiry_date from user_users;
works for me. Caveat: this works only for the user you are logged on as.
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.
Issue this command:
select username, account_status, expiry_date, profile from dba_users;
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?