CREATE EXTERNLOGIN Statement

Quick Links:

Syntax

CREATE EXTERNLOGIN login-name 
   TO remote-server 
   REMOTE LOGIN remote-user 
   [ IDENTIFIED BY remote-password ]

Parameters

(back to top)

login-name – specifies the local user login name. When using integrated logins, the login-name is the database user to which the Windows user ID is mapped.

TO – specifies the name of the remote server.

REMOTE LOGIN – specifies the user account on remote-server for the local user login-name.

IDENTIFIED BY – specifies that remote-password is the password for remote-user. If you omit the IDENTIFIED BY clause, the password is sent to the remote server as NULL. If you specify IDENTIFIED BY " " (an empty string), the password sent is the empty string.

Examples

(back to top)

Example 1 – maps the local user named DBA to the user sa with password 4TKNOX when connecting to the server sybase1:
```
CREATE EXTERNLOGIN dba 
TO sybase1 
REMOTE LOGIN sa
IDENTIFIED BY 4TKNOX
```

Usage

(back to top)

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

By default, SAP Sybase IQ uses the names and passwords of its clients whenever it connects to a remote server on behalf of those clients. CREATE EXTERNLOGIN assigns an alternate login name and password to be used when communicating with a remote server. It stores the password internally in encrypted form.

The remote_server must be known to the local server by an entry in the ISYSSERVER system table. For more information, see the CREATE SERVER Statement.

Creating a remote login with the CREATE EXTERNLOGIN statement and defining a remote server with a CREATE SERVER statement sets up an external login and password for the INSERT...LOCATION such that any user can use the login and password in any context. This avoids possible errors due to inaccessibility of the login or password, and is the recommended way to connect to a remote server.

Note: If you rely on the user ID and password of the current connection, and a user changes the password, you must stop and restart the server before the new password takes effect on the remote server. Remote logins created with CREATE EXTERNLOGIN are unaffected by changes to the password for the default user ID.

Sites with automatic password expiration should plan for periodic updates of passwords for external logins.

CREATE EXTERNLOGIN cannot be used from within a transaction.

The remote-user and remote-password combination must be valid on remote-server.

Side Effects

Automatic commit

Standards

(back to top)

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

Permissions

(back to top)

Requires the MANAGE ANY USER system privilege.