To mark a user's account as expired, use the following query.
SQL>alter user aUser identified by qwerty password expire;
User altered.
Then, try to connect. You will see ora-28001 error.
SQL> conn aUser/qwerty
ERROR:
ORA-28001: the password has expired
Finally, it will prompt you a change password dialog.
Changing password for aUser
New password:
Retype new password:
Password changed
Connected.
|