PASSWORDS

Contains user passwords information. This table stores current passwords and past passwords if any Profiles have PASSWORD_REUSE_TIME or PASSWORD_REUSE_MAX parameters set. See CREATE PROFILE for details.

Column Name Data Type Description
USER_ID

INTEGER

The ID of the user who owns the password.

USER_NAME

VARCHAR

The name of the user who owns the password.

PASSWORD

VARCHAR

The encrypted password.

PASSWORD_CREATE_TIME

DATETIME

The date and time when the password was created.

IS_CURRENT_PASSWORD

BOOLEAN

Denotes whether this is the user's current password. Non-current passwords are retained to enforce password reuse limitations.

PROFILE_ID

INTEGER

The ID number of the profile to which the user is assigned.

PROFILE_NAME

VARCHAR

The name of the profile to which the user is assigned.

PASSWORD_REUSE_MAX

VARCHAR

The number password changes that must take place before an old password can be reused.

PASSWORD_REUSE_TIME

VARCHAR

The amount of time that must pass before an old password can be reused.