ASA SQL User's Guide
  Accessing Remote Data
    Working with external logins

Dropping external logins

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

Only the login-name and the DBA account 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. Right-click the external login and choose Delete from the popup menu.

To delete an external login (SQL)

1. Connect to the host database from Interactive SQL.

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 ASEserver

See also

• DROP EXTERNLOGIN statement