Removing a System Privilege from a System Role

Remove a system privilege from a system role.

Prerequisites

Database Version	Role-Based System Role Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	Requires MANAGE ROLES system privilege along with administrative rights over the system privilege.

Task

You cannot remove the underlying system privilege granted to a system role.

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

Note: The Revoke button is unavailable if the selected system privilege is a default underlying system privilege of the system role, or you do not have administrative rights to the system privilege.
Click OK.