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


SYSLOGINMAP system view

The SYSLOGINMAP system view contains one row for each user that can connect to the database using either an integrated login, or Kerberos login. As a security measure, only users with DBA authority can view the contents of this view. The underlying system table for this view is ISYSLOGINMAP.

Column name Column type Description
login_mode TINYINT The type of login: 1 for integrated logins, 2 for Kerberos logins.
login_id VARCHAR(1024) Either the integrated login user profile name, or the Kerberos principal that maps to database_uid.
object_id UNSIGNED BIGINT A unique identifier, one for each mapping between user ID and database user ID.
database_uid UNSIGNED INT The database user ID to which the login ID is mapped.
Constraints on underlying system table

PRIMARY KEY (login_mode, login_id)

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

FOREIGN KEY (database_uid) references SYS.ISYSUSER (user_id)