Contents Index Working with external logins Dropping external logins

ASA SQL User's Guide
  Accessing Remote Data
    Working with external logins

Creating 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)

  1. Connect to the host database from Sybase Central.

  2. Open the Remote Servers folder for that database and select the remote server.

  3. From the File menu, choose New > External Login.

    The External Login Creation wizard appears.

  4. Follow the instructions in the wizard.

To create an external login (SQL)

  1. Connect to the host database from Interactive SQL.

  2. Execute a CREATE EXTERNLOGIN statement.

Example 

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.


Contents Index Working with external logins Dropping external logins