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.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0