Removing a System Privilege from a User-Extended Role

Remove a system privilege from a user-extended role.

Prerequisites

Database Version	Role-Based User-Extended Role Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	Requires administrative rights over the system privilege. Administrative rights on the role is not required.

Task

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 user-extended 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 user-extended role appears.
Highlight a system privilege and click Revoke.

Note: The Revoke button is unavailable if you do not have administrative rights to the selected system privilege.
Click OK.

Created May 21, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com