DROP EXTERNLOGIN Statement

Drops an external login from the SAP Sybase IQ system tables.

Syntax

DROP EXTERNLOGIN login-name 
   TO remote-server

Parameters

login-name – specifies the local user login name.

TO – specifies the name of the remote server. The alternate login name of the local user and password for that server is the external login that is deleted.

Examples

Example 1 – drops the login dba from the remote database sybase1:
```
DROP EXTERNLOGIN dba TO sybase1
```

Usage

Changes made by DROP EXTERNLOGIN do not take effect until the next connection to the remote server.

Side Effects

Automatic commit

Standards

SQL—ISO/ANSI SQL compliant.
Sybase—Supported by Open Client/Open Server.

Permissions

Requires the MANAGE ANY USER system privilege.

Parent topic: SQL Statements

Related reference

CREATE EXTERNLOGIN Statement

Created May 22, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com