Generating DDL Commands for Sybase IQ Users or Groups

Display the SQL code for creating a user or group. The SQL code can be a useful reference and training tool.

Prerequisites
User Admin authority is required.
Task
  1. In the Perspective Resources view, select a resource.
  2. From the application menu bar, select View > Open > Administration Console.
  3. In the left pane of the Administration Console, select Security > Users or Security > Groups.
  4. Select the user or group from the right pane and either:
    • Click the arrow to the right of the name and select Generate DDL
    • From the Administration Console menu bar, select Resource > Generate DDL
    The DDL tab opens, showing the SQL code used to create the selected user or group.
Related tasks
Viewing Properties for Sybase IQ Users or Groups
Adding a Sybase IQ User or Group
Deleting a Sybase IQ User
Deleting a Sybase IQ Group
Adding a Member to a Sybase IQ Group
Removing a Sybase IQ User from a Group
Changing a Sybase IQ User to a Group
Changing a Sybase IQ Group to a User