Here's how to get password expiration information without DBA privileges.
SQL> select * from user_password_limits;
RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
7 rows selected.
SQL> select account_status,expiry_date from user_users;
ACCOUNT_STATUS EXPIRY_DA
-------------------------------- ---------
OPEN 03-JAN-15
At some point, I need to collect all my DBA-free Oraclejitsu into a single document. But I say the same thing to that that I say to death: "Not today."
Friday, July 11, 2014
Subscribe to:
Posts (Atom)