Removing a Grantee from a System Privilege

Remove a user or role as a member (grantee) of a system privilege grant list.

Prerequisites

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

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Security > Role-Based, and then select 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 user or role to be removed and click Revoke.

Note: The Revoke button is unavailable if you do not have administrative rights to the selected system privilege.
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.