Generating External Login DDL Commands

Generate data description language for one or more external login. The DDL can be a useful resource and training tool.

Prerequisites
Database Version External Login Privileges
SAP Sybase IQ 15.3 and 15.4 None
SAP Sybase IQ 16.0 None
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. Select the external login 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 external logins.
    The DDL view opens, showing the SQL code used to create the selected external login(s).
Related tasks
Creating an External Login
Deleting an External Login
Viewing External Login Properties
Authenticating a Login Account for a Managed Resource
Related reference
External Login Privilege Summary