DROP EXTERNLOGIN statement

Drops an external login from the database.

Syntax

Drop an external login

DROP EXTERNLOGIN login-name TO remote-server

Drop an external login (include variables in syntax)

DROP EXTERNLOGIN USER string | variable SERVER string | variable

Parameters

DROP clause
Specify the local user login ID.
SERVER clause
Specify the name of the remote server. The local user's alternate login name and password for that server is the external login that is deleted.

Remarks

DROP EXTERNLOGIN deletes an external login from the database.

Note For required parameters that accept variable names, the database server returns an error if any of the following conditions is true:

Privileges

You must have the MANAGE ANY USER system privilege.

Side effects

Automatic commit.

Standards

Example

The following example drops the DBA external login to the fictitious remote server, sybase1.

DROP EXTERNLOGIN DBA TO sybase1;