Sybase IQ uses the names and passwords of its clients when it connects to a remote server on behalf of those clients. However, this behavior can be overridden by creating external logins. External logins are alternate login names and passwords that are used when communicating with a remote server.
When Sybase IQ connects to the remote server, INSERT...LOCATION uses the remote login for the user ID of the current connection, if a remote login has been created with CREATE EXTERNLOGIN and the remote server has been defined with a CREATE SERVER statement. If the remote server is not defined or a remote login has not been created for the user ID of the current connection, IQ connects using the user ID and password of the current connection. For an example of INSERT...LOCATION using a remote login, see “INSERT statement” in Chapter 6, “SQL Statements” of the Sybase IQ Reference Manual.
If you are using an integrated login, then the IQ name and password of the IQ client is the same as the database userid and password that the IQ userid maps to in syslogins.
