Expired (Grace) Oracle Account

A user indicated he was getting the error below, but could still connect.

ORA-28002: the password will expire within 7 days

In Oracle 11g, the default expiration date for the “DEFAULT” profile has changed from UNLIMITED to 180 days.  Changed the setting with the SQL below.

ALTER PROFILE default LIMIT PASSWORD_LIFE_TIME unlimited;

Note:  This change only affects accounts who have not entered their grace period.  Accounts that have entered their grace period will have to change their passwords.

Must make a note in my database creation scripts to adjust this setting to UNLIMITED.  Not saying this is a good decision for a production database, but for my development and lab databases this will eliminate the problem with an expiring account.

Advertisements

One Response to Expired (Grace) Oracle Account

  1. bookkeeping says:

    wedding carriges…

    […]Expired (Grace) Oracle Account « Mike R's Blog[…]…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: