Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 8302
  • Last Modified:

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?

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.
1 Solution
Expiry date mentioned in  dba_users is basically means Date of expiration of the account (or the user). The user with EXPIRED status has expiry_date as " 06/26/01", whereas others have  expiry date much later than that(2003, 2004). So check this out. It has nothing to do with password change. DBA will have to update the expiry dates as well as change the status for the user.

ALTER USER test VALID UNTIL 'Jan 31 2340';

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now