|
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 |
|---|---|---|
| login_mode | TINYINT | NOT NULL |
| login_id | VARCHAR(1024) | NOT NULL |
| 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)