9i : Expired account
Hello,
Normally in 9i, when an account is expired, the user is forced to enter a new password on the next login but this is not working :
SQL DEVELOPER V 3.2
connect test/test@db;
--Connected
alter user test password expire ;
--user TEST altered.
SELECT username, account_status, expiry_date FROM dba_users where username = 'TEST';
USERNAME ACCOUNT_STATUS EXPIRY_DATE
------------------------------ -------------------- ------------ -----------
TEST EXPIRED 04/23/21
connect test/test @db;
--Connection Failure
SQL DEVELOPER: No invitation to change password !!! Why ?
And how to force user using Software Application to change password when his account is EXPIRED.
Best regards.
GD.