Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » System Objects » Views » System views


SYSUSER system view

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 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.
login_policy_id UNSIGNED BIGINT A unique identifier for the login policy.
expired_password_on_login TINYINT Indicates if the user's password expires at the next login.
password_creation_time TIMESTAMP The time the user's password was created.
failed_login_attempts UNSIGNED INT The number of times a user can fail to log in before the account is locked.
last_login_time TIMESTAMP The time the user last logged in.
Constraints on underlying system table

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)

See also