The user expiration date is an optional part of the user definition. It determines the date after which the user can no longer access Ingres.

An expiration date can be specified as any valid Ingres date or as a date or time interval. For example, you might specify an interval of ‘1 month’ or ‘1 year,’ or an absolute date, such as ‘5‑jan‑2007.’

The user expiration date is checked each time the user connects to the DBMS Server. If the expiration date has passed, then access is denied.

To enable an expired user to connect, the associated user (or profile) object must be modified to reset the expiration date.