Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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||Column constraint|
|object_id||UNSIGNED BIGINT||NOT NULL|
|database_uid||UNSIGNED INT||NOT NULL|
login_mode The type of login: 1 for integrated logins, 2 for Kerberos logins.
login_id Either the integrated login user profile name, or the Kerberos principal that maps to database_uid.
object_id A unique identifier, one for each mapping between user ID and database user ID.
database_uid The database user ID to which the login ID is mapped.
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)