Reference Manual
CHAPTER 9. SQL Statements
To assign an alternate login name and password to be used when communicating with a remote server.
CREATE EXTERNLOGIN login-name
TO remote-server
REMOTE LOGIN remote-user
[ IDENTIFIED BY remote-password ]
Only the login-name and the DBA account can add or modify an external login for login-name.
Supported on Windows 95 and Windows NT only.
Automatic commit.
By default, Adaptive Server Anywhere uses the names and passwords of its clients whenever it connects to a remote server on behalf of those clients. CREATE EXTERNLOGIN assigns an alternate login name and password to be used when communicating with a remote server. It stores the password internally in encrypted form. The remote_server must be known to the local server by an entry in the sysservers table. For more information, see CREATE SERVER Statement.
Sites with automatic password expiration should plan for periodic updates of passwords for external logins.
CREATE EXTERNLOGIN cannot be used from within a transaction.
login-name specifies the local user login name.
TO clause The TO clause specifies the name of the remote server.
REMOTE LOGIN clause The REMOTE LOGIN clause specifies the corresponding user account on remote-server for the local user login-name.
IDENTIFIED BY clause The IDENTIFIED BY clause specifies remote-password is the password for remote-user
remote-user and remote-password must be a valid combination on the node where the remote-server runs.
SQL/92 Entry-level feature.
Sybase Supported by Open Client/Open Server.
Map the local user named dba to the user sa when connecting to the server sybase1.
CREATE EXTERNLOGIN dba TO sybase1 REMOTE LOGIN sa IDENTIFIED BY monkey