Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center