Removing a Role from a Role-Based User

Remove a role-based user's membership in a role.

Prerequisites

Database Version	Role-Based User Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	Requires one of: Administrative rights over the role (role administrator). MANAGE ROLES system privilege if the role has a global role administrator.

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

Task

By default, a minimum of one role administrator (or global role administrator with a login password) for each role must exist at all times. This minimum requirement is validated before you can remove a member who is a role administrator from a role.

If removing membership in a role would result in a failure to meet the minimum number of role administrators for the selected role, an error message appears, and the task fails.

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

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