Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Working with external logins

Working with external logins Next Page

Creating external logins

You can create an external login using either Sybase Central or the CREATE EXTERNLOGIN statement.

Only the DBA or user who will be using the external login 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 then select the remote server.

  3. Click the External Logins tab.

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

    The Create External Login wizard appears.

  5. 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.

    3. Example

    The following statement allows the local user fred to gain access to the server RemoteASE, using the remote login frederick with password banana.

    CREATE EXTERNLOGIN fred
TO RemoteASE
REMOTE LOGIN frederick
IDENTIFIED BY banana;

    For more information, see CREATE EXTERNLOGIN statement.