oracle profile status and expire date
Posted on 2005-04-21
I have oracle 9i database on unix sun.
When I checked the status of oracle user id in dba_users as follows:
SELECT username, user_id, account_status, expiry_date
FROM dba_users ;
some user shows account status as open but they have expired date in 2004.
profile forces 90 day password change limitation and 10 day's grace.
does it mean that it got expired on that expired date but later user changed there password so it indicates status as open ? or profile is not working?
USERNAME USER_ID ACCOUNT_STATUS LOCK_DATE EXPIRY_DATE CREATED
A 1 OPEN [NULL] 12/28/03 09/29/03
B 2 OPEN [NULL] 04/19/04 01/20/04
C 3 EXPIRED [NULL] 06/22/04 06/26/01
Thank you very much.