ASA SQL Reference
System Tables
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.