Link to home
Start Free TrialLog in
Avatar of dcmumbai
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
ASKER CERTIFIED SOLUTION
Avatar of sujit_kumar
sujit_kumar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial