|
Each row in the SYSEXTERNLOGIN system view describes an external login for remote data access. The underlying system table for this view is ISYSEXTERNLOGIN.
NotePrevious versions of the catalog contained a SYSEXTERNLOGINS system table. That table has been renamed to be ISYSEXTERNLOGIN (without an 'S'), and is the underlying table for this view. |
| Column name | Column type | Column constraint |
|---|---|---|
| user_id | UNSIGNED INT | NOT NULL |
| srvid | UNSIGNED INT | NOT NULL |
| remote_login | VARCHAR(128) | |
| remote_password | VARBINARY(128) |
user_id The user ID on the local database.
srvid The remote server, as listed in the SYSSERVER system view.
remote_login The login name for the user, for the remote server.
remote_password The password for the user, for the remote server.
PRIMARY KEY (user_id, srvid)
FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)
FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)