Adding the Global Role Administrator to a Standalone Role

Add the global role administrator to an existing standalone role.

Prerequisites
Database Version Global Role Administrator Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 You must have administrative rights over the role being managed.
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Security > Role-Based, and then select Standalone Roles.
  3. Select a role from the right pane and either:
    • Click the arrow to the right of the name and select Manage Grantee, or
    • From the Administration Console menu bar, select Resource > Manage Grantee.
    Note: The Manage Grantee option is unavailable if you do not have rights to manage the role.
  4. Click Grant.
  5. Select MANAGE ROLES and click OK.
    Note: The MANAGE ROLES system privilege is not listed if you do not have administrative rights to the privilege.
  6. Highlight MANAGE ROLES, click in the Privileges column, and click the arrow. Select Administrative only.
    Warning!  Selecting any other privilege combination results in an error, and the privilege is not granted.
  7. Do one of:
    • Click OK to update any changes to the database and exit the properties view.
    • Click Apply to update any changes to the database, but remain in the properties view.
    • Click Cancel to cancel any changes not updated to the database and exit the properties view.
Related concepts
DBA User or Global Role Administrators Are Unable to Manage a Standalone Role
Related tasks
Removing the Global Role Administrator from a Standalone Role
Authenticating a Login Account for a Managed Resource