dcmumbai
asked on
oracle profile status and expire date
Hi ,
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.
DC
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.
DC
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.