CREATE EXTERNLOGIN statement

Description

Assigns an alternate login name and password to be used when communicating with a remote server.

Syntax

CREATE EXTERNLOGIN login-name 
TO remote-server 
REMOTE LOGIN remote-userIDENTIFIED BY remote-password ]

Examples

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

By default, 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 CREATE SERVER statement.

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

CREATE EXTERNLOGIN cannot be used from within a transaction.

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 The TO clause specifies the name of the remote server.

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

IDENTIFIED BY The IDENTIFIED BY clause specifies 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), then the password sent is the empty string.

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


Side effects

Automatic commit.

Standards

Permissions

Only users with DBA authority can add or modify an external login for login-name.

See also

DROP EXTERNLOGIN statement

INSERT statement