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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSTYPEMAP system view Next Page

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.

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

Constraints on underlying system table

PRIMARY KEY (user_id)

FOREIGN KEY (object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL