Creating external logins

Only the login-name and the DBA account can add or modify an external login.

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 in Sybase IQ Reference Manual.