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 ]
login-name specifies the local user login name. When using integrated logins, the login-name is the database user to which the Windows user or group is mapped.
If you omit the IDENTIFIED BY clause, the password is sent to the remote server as NULL. However, if you specify IDENTIFIED BY "" (an empty string), then the password sent is the empty string.
By default, SQL 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 ISYSSERVER table. 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.
Only users with DBA authority can add or modify an external login for login-name.
Not supported on Windows Mobile.
SQL/2003 Vendor extension.
Map the local user named DBA to the user sa with password Plankton when connecting to the server sybase1.
CREATE EXTERNLOGIN DBA TO sybase1 REMOTE LOGIN sa IDENTIFIED BY Plankton;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|