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

Creating external logins Next Page

Dropping external logins

You can use either Sybase Central or a DROP EXTERNLOGIN statement to delete an external login from the SQL Anywhere system tables.

Only the DBA or user who will be using the external login can delete an external login.

To delete an external login (Sybase Central)
  1. Connect to the host database from Sybase Central.

  2. Open the Remote Servers folder.

  3. In the left pane, select the remote server and then click the External Logins tab in the right pane.

  4. Select the external login, and then choose File > Delete.

To delete an external login (SQL)
  1. Connect to the host database from Interactive SQL.

  2. Execute a DROP EXTERNLOGIN statement.

  3. Example

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

    See also