ASA SQL User's Guide
Accessing Remote Data
Working with external logins
You can create an external login using either Sybase Central or the CREATE EXTERNLOGIN statement.
Only the login-name and the DBA account can add or modify an external login.
To create an external login (Sybase Central)
Connect to the host database from Sybase Central.
Open the Remote Servers folder for that database and select the remote server.
From the File menu, choose New
The External Login Creation wizard appears.
Follow the instructions in the wizard.
To create an external login (SQL)
Connect to the host database from Interactive SQL.
Execute a CREATE EXTERNLOGIN statement.
The following statement allows the local user fred to gain access to the server ASEserver, using the remote login frederick with password banana.
CREATE EXTERNLOGIN fred TO ASEserver REMOTE LOGIN frederick IDENTIFIED BY banana
For more information, see CREATE EXTERNLOGIN statement.