This section explains the procedure for releasing individual users from password-invalid account lock state. You must perform the steps in order they are shown below, beginning with step (1).
Check for users in password-invalid account lock state. An example follows:
SELECT USER_ID
FROM MASTER.SQL_USERS
WHERE PWD_LOCK_TIME IS NOT NULL
USER_ID |
Use a GRANT statement to change the password of a user who is in password-invalid account lock state. Examples follow:
GRANT CONNECT TO USER01 IDENTIFIED BY "f51HD7tc"