Creating an External Login

Define an alternate login name and password by specifying the remote server to create an external login for, and the local user the external login applies to.

Prerequisites
Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • USER ADMIN authority
SAP Sybase IQ 16.0 You must have the MANAGE ANY USER system privilege.
Note: You must define a remote server before you can create an external login.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Networks, and then select External Login.
  3. Click the arrow next to External Logins and select New.
    The Create External Login Wizard appears.
  4. On the Server and User page, specify:
    Option Description
    Resource The resource (server) that the external login will be created on.
    Remote Server The defined remote server which the external login will be used to connect to.
    User The defined local user for whom the alternate login name and password (external login) will be created.
  5. Click Next.
  6. On the External Login page, specify:
    Option Description
    Login name The user ID to be used on the remote server by the previously selected locally defined user.
    Password The password for validating the user ID on the remote server. If the user has no password on the remote server , leave it blank.
    Confirm password If you enter a password, re-type it as verification.
  7. Click Finish.
Related tasks
Deleting an External Login
Generating External Login DDL Commands
Viewing External Login Properties
Authenticating a Login Account for a Managed Resource
Related reference
External Login Privilege Summary