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