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.