Dropping external logins

Use one of the following procedures to delete an external login from the SQL Anywhere system tables.

To delete 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. Select the external login, and then choose File » Delete.

  5. Click Yes.

To delete 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 DROP EXTERNLOGIN statement.

Example

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

DROP EXTERNLOGIN fred TO RemoteASE;
See also