Contents Index SYSEXTENT system table SYSFILE system table

ASA SQL Reference
  System Tables

SYSEXTERNLOGINS system table


Column name Column type Column constraint Table constraints
user_id UNSIGNED INT NOT NULL Primary key. Foreign key to SYSUSERPERM
srvid INTEGER NOT NULL Primary key. Foreign key to SYSSERVERS
remote_login VARCHAR(128)
remote_password VARBINARY(128)

Each row describes an external login for remote data access.

user_id    The user ID on the local database.

srvid    The remote server, as listed in SYSSERVERS.

remote_login    The login name for this user, for the remote server.

remote_password    The password for this user, for the remote server.


Contents Index SYSEXTENT system table SYSFILE system table