Adding the Global Role Administrator to a User-Extended Role

Add the global role administrator to an existing user-extended role.

Prerequisites

Database Version	Global Role Administrator Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	Requires administrative rights over the role being managed.

The SAP Sybase IQ resource is authenticated and running.
The selected resource supports role-based security

Task

To add the global role administrator, you must add the MANAGE ROLES system privilege to the list of grantees (Manage Grantees) for the role. Since MANAGE ROLES is a system privilege, it may also be added to the list of granted system privileges (Manage System Privilege) for the role. However, adding the MANAGE ROLES system privilege from the granted system privileges list does not add the global role administrator to the role.

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Security > Role-Based > User-Extended Roles.
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.
Click Grant.
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.
Highlight MANAGE ROLES, click in the Grant Option column, and click the arrow. Select Administrative only.

Warning! Selecting any other Grant Option results in an error, and the MANAGE ROLES system privilege is not granted.
Click OK.