when i do the following in 11g database, the account is only LOCKED, not LOCKED(TIMED) as 10g. i have some other 11g database also showing LOCKED(TIMED).
I want the status to show LOCKED(TIMED) when user typed wrong password for a few times. and i want the status to show "LOCKED" when DBA manually lock the account. is there somewhere we can control this? or this is a 11g new thing?
create user test123 identified by test123;
grant create session to test123;
create profile test_profile limit FAILED_LOGIN_ATTEMPTS 1;
alter user test123 profile test_profile;
conn / as sysdba
select username, account_status from dba_users where username = 'TEST123';