Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSEVENTTYPE system view Next Page

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.

Columns
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.

Constraints on underlying system table

PRIMARY KEY (user_id, srvid)

FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)

FOREIGN KEY (srvid) references SYS.ISYSSERVER (srvid)