|
Each row in the SYSUSER system view describes a user in the system. The underlying system table for this view is ISYSUSER.
| Column name | Column type | Column constraint |
|---|---|---|
| user_id | UNSIGNED INT | NOT NULL |
| object_id | UNSIGNED BIGINT | NOT NULL |
| user_name | CHAR(128) | NOT NULL |
| password | BINARY(128) |
user_id A number uniquely identifying the user in the system.
object_id The internal ID for the user, uniquely identifying the user in the database.
user_name The login name for the user.
password The user's password.
PRIMARY KEY (user_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL