DROP EXTERNLOGIN Statement

Go to Parameters

Go to Examples

Go to Usage

Go to Standards

Go to Permissions

Syntax

DROP EXTERNLOGIN login-name 
   TO remote-server

Parameters

(back to top)

• 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

(back to top)

• Example 1 – drops the login dba from the remote database sybase1:

  DROP EXTERNLOGIN dba TO sybase1

Usage

(back to top)

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

Standards

(back to top)

Permissions

(back to top)

Requires the MANAGE ANY USER system privilege.