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. |