Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Accessing remote data » Working with external logins

 

Creating external logins

Use one of the following procedures to create an external login.

To create an external login (Sybase Central)

  1. Connect to the host database as a user with DBA authority or as the owner of the external login.

  2. In the left pane, double-click Remote Servers.

  3. Select the remote server, and in the right pane click the External Logins tab.

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

  5. Follow the instructions in the Create External Login Wizard.

To create an external login (SQL)

  1. Connect to the host database as a user with DBA authority or as the owner of the external login.

  2. Execute a CREATE EXTERNLOGIN statement.

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.