Generating Login Mapping DDL Commands

Display the data description language SQL code for adding a login mapping to the database. The SQL code can be a useful reference and training tool.

Prerequisites

Database Version	Login Mapping Privileges
SAP Sybase IQ 15.3 and 15.4	You must have SELECT permission on the SYSLOGINMAP view.
SAP Sybase IQ 16.0	You must have 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.

Note: If you do not have the SELECT ANY TABLE system privilege or SELECT permission on the SYSLOGINMAP view, the list of login mappings is empty.
Select one or more login mappings from the right pane and either:
- Click the arrow to the right of the name and select Generate DDL, or
- From the Administration Console menu bar, select Resource > Generate DDL.
Tip: Use Shift-click or Control-click to select multiple login mappings.

The DDL view shows the SQL code used to create the selected login mappings.