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

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » 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 Data 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