User's Guide
   PART 4. Database Administration and Advanced Use
     CHAPTER 28. Accessing Remote Data       

Working with external logins

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. However, this default can be overridden by creating external logins. External logins are alternate login names and passwords to be used when communicating with a remote server.

  Creating external logins

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.

  Creating external logins from Sybase Central

  To create an external login using Sybase Central (Java):

1. Connect to the host database from Sybase Central (Java) using a JDBC connection.

2. In the left panel, open the Remote Server folder. Then right-click the remote server on the right panel.

3. Select Properties from the popup menu. Change to the External Logins tab and make the changes you need in the property sheet.

4. Click OK to save the changes.

  Dropping external logins

Use the DROP EXTERNLOGIN statement to remove external logins from the Adaptive Server Anywhere system tables.

Example 

The following statement drops the external login for the local user fred created in the example above:

DROP EXTERNLOGIN fred TO ASEserver 

     For more information, see DROP EXTERNLOGIN statement.