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	Requires one of: DBA authority. USER ADMIN authority along with SELECT permission on the SYSLOGINMAP view.
SAP Sybase IQ 16.0	Requires 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 are licensed for the Advanced Security option (IQ_SECURITY), if mapping a Kerberos principal.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Security > 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.
On the Comment page, enter an (optional) 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.