Creating a Login Mapping

Create a login mapping to allow easier connection to a network server on Windows or a database that uses the Kerberos network authentication protocol.

Prerequisites

Database Version	Login Mapping Privileges
SAP Sybase IQ 15.3 and 15.4	You must have one of: DBA authority USER ADMIN authority along with SELECT permission on the SYSLOGINMAP view
SAP Sybase IQ 16.0	You must have the MANAGE ANY USER system privilege along with one of: SELECT ANY TABLE system privilege SELECT permission on the SYSLOGINMAP view

The SAP Sybase IQ resource is authenticated and running.
You must be licensed for the Advanced Security option (IQ_SECURITY), if you are mapping a Kerberos principal.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Security, and then select Login Mappings.
Click the arrow next to Login Mappings and select New.
The Create Login Mapping Wizard appears.

On the Welcome page, specify:

Option	Description
Which type of login mapping do you want to create?	From the list, select Kerberos to map a Kerberos principal or Integrated to map a Windows user profile.
Select a resource for which the login mapping will be created.	From the list, select the name of the server.
What do you want to name the login mapping?	Enter a unique name for the new login map; maximum 128 characters.
Which database user do you want to associate with the login mapping?	From the list, select the name of the user.

Click Next to add a Comment, or Finish.
(Optional) On the Comment page, enter a comment for the login mapping.
Click Finish.

Note: If you do not have the SELECT ANY TABLE system privilege or SELECT permission on the SYSLOGINMAP view, the login mapping is successfully created, but does not appear on the list.