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

SQL Anywhere 11.0.1 (Français) » 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.
NOTE

For databases created using SQL Anywhere version 11.0.0 and later, the underlying system table for this view is always encrypted to protect the data from unauthorized access.

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