The SYSLOGINMAP system view contains one row for each user that can connect to the database using either an integrated login, or Kerberos login. For that reason, access to this view is restricted. 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. |
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)