Each row in the SYSUSER system view describes a user in the system. Standalone roles are also stored in this view as well, but only the user_id, object_id, user_name, and user_type columns are meaningful for these roles. The underlying system table for this view is ISYSUSER.
Column name | Data type | Description |
---|---|---|
user_id | UNSIGNED INT | A unique identifier for the user assigned to the login policy. |
object_id | UNSIGNED BIGINT | A unique identifier for the user in the database. |
user_name | CHAR(128) | The login name for the user. |
password | BINARY(128) | The password for the user. For security, data in this column is visible only to users with the SELECT ANY TABLE system privilege. |
login_policy_id | UNSIGNED BIGINT | A unique identifier for the login policy. |
expired_password_on_login | TINYINT | A value that indicates if the password for the user expires at the next login. |
password_creation_time | TIMESTAMP | The local time that the password was created for the user. |
failed_login_attempts | UNSIGNED INT | The number of times that a user can fail to log in before the account is locked. |
last_login_time | TIMESTAMP | The local time that the user last logged in. |
user_type | TINYINT |
A value that indicates whether the user is a regular user, or a role, or a user extended as a role. And whether the user, role, or extended role can be altered (mutable) or removed. Possible values:
|
user_dn | CHAR (1024) | An LDAP Distinguished Name (DN) identifier for the user that is unique within a domain and across domains. The DN is used to authenticate with an LDAP server. |
user_dn_cached_at | TIMESTAMP | The time that the user_dn column was last cached. This value is used to determine whether to purge an old DN. Regardless of the database server local time zone, the value is stored in Coordinated Universal Time (UTC). |
password_creation_time_utc | TIMESTAMP WITH TIME ZONE | The UTC time that the password was created for the user. |
last_login_time_utc | TIMESTAMP WITH TIME ZONE | The UTC time that the user last logged in. |
dual_password | BINARY(128) | The first and/or second parts of the dual password for the user. For security, data in this column is visible only to users with the SELECT ANY TABLE system privilege. |
lock_time | TIMESTAMP | Timestamp at which user was locked due to failed login attempts. |
PRIMARY KEY (user_id)
FOREIGN KEY (object_id) REFERENCES SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (login_policy_id) REFERENCES SYS.ISYSLOGINPOLICY (login_policy_id)
UNIQUE INDEX (user_name)