Generating Authority-Based Group DDL Commands

Display the SQL data description language for creating a group. The SQL code can be a useful reference and training tool.

Prerequisites
Database Version Authority-Based Group Permissions
SAP Sybase IQ 15.3 and 15.4 None.
SAP Sybase IQ 16.0 Not supported.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Security > Authority-Based, and then select Groups.
  3. Select one or more groups 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 groups.
    The DDL view opens, showing the SQL code used to create the selected authority-based groups.
Related tasks
Creating an Authority-Based Group
Deleting an Authority-Based Group
Converting an Authority-Based Group to a User
Adding Authority-Based Users and Groups to Groups
Removing Authority-Based Users or Groups from a Group
Viewing or Modifying Authority-Based Group Options
Viewing or Modifying Authority-Based Group Properties
Adding an Authority to a Group
Removing an Authority from a Group
Authenticating a Login Account for a Managed Resource
Related reference
Authority-Based Group Privilege Summary