## unlock oracle user account of my_user
>Login as SYSTEM
SQL>ALTER USER my_username IDENTIFIED BY my_new_password ACCOUNT UNLOCK;
##check password lifetime
SQL>SELECT resource_name, limit FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_type = 'PASSWORD';
##Change default limit to unlimited in ORACLE
SQL>ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Thursday, November 14, 2019
Subscribe to:
Posts (Atom)