Chapter 9 SQL Statements
443
CREATE EXTERNLOGIN statement
Use this statement to assign an alternate login name and password to be used
when communicating with a remote server.
CREATE EXTERNLOGIN
login-name
TO
remote-server
REMOTE LOGIN
remote-user
[ IDENTIFIED BY
remote-password
]
Only the login-name and the DBA account can add or modify an external
login for login-name.
Supported on Windows 95 and Windows NT only.
Automatic commit.
"DROP EXTERNLOGIN statement" on page 509
By default, Adaptive Server Anywhere 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.
The password is stored internally in encrypted form. The remote-server must
be known to the local server by an entry in the
SYSERVERS
table. For more
information, see "CREATE SERVER statement" on page 464.
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 NT user
ID is mapped.
TO clause The TO clause specifies the name of the remote server.
REMOTE LOGIN clause The REMOTE LOGIN clause specifies the user
account on remote-server for the local user login-name.
IDENTIFIED BY clause The IDENTIFIED BY clause specifies the
remote-password for remote-user. The remote-user and remote-password
combination must be valid on the remote-server.
♦
SQL/92 Entry-level feature.
♦
Sybase Supported by Open Client/Open Server.
Function
Syntax
Permissions
Side effects
See also
Description
Parameters
Standards and
compatibility
To Next Page
Loading...