Changing a Grantee's Administrative Rights on a System Privilege

Change a user or role's ability to manage a system privilege.

Prerequisites

Database Version	Role-Based System Privilege Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	Requires administrative rights over any system privilege.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Security > Role Based > System Privileges.
Select a system privilege from the right pane and either:
- Click the arrow to the right of the name and select Manage Grantees, or
- From the Administration Console menu bar, select Resource > Manage Grantees.
A list of users and roles currently granted to the system privilege appears.

Highlight a grantee to be modified. Click in the Grant Options column, click the arrow, and select the administrative rights to be granted.

Grant Option	Description
Privilege only	(default) Grantees can perform authorized tasks requiring the selected privilege, but cannot grant the system privilege to other users and roles.
Administrative only	Grantees can grant and revoke the selected system privilege to other users and roles, but cannot perform authorized tasks requiring the selected system privilege.
Administrative and privilege	Grantees can grant and revoke the selected system privilege to other users and roles and can perform authorized tasks requiring the selected system privilege.