SYSEXTERNLOGIN system view

Each row in the SYSEXTERNLOGIN system view describes an external login for remote data access. The underlying system table for this view is ISYSEXTERNLOGIN.

Note

Previous 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 Data type Description
user_id UNSIGNED INT The user ID on the local database.
srvid UNSIGNED INT The remote server, as listed in the SYSSERVER system view.
remote_login VARCHAR(128) The login name for the user, for the remote server.
remote_password VARBINARY(128) The password for the user, for the remote server.
Note

For databases created using SQL Anywhere 12, the underlying system table for this view is always encrypted to protect the data from unauthorized access.

 Constraints on underlying system table