Deleting a Compatibility Role

Delete a compatibility role from the database.

Prerequisites

Database Version	Role-Based Compatibility Role Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	You must have administrative rights over the compatibility role being deleted.

The SAP Sybase IQ resource is authenticated and running.
The selected resource supports role-based security
All of a compatibility role's underlying system privileges must have been granted to at least one user-defined role.
No users or roles are currently granted to the compatibility role.

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 Compatibility Roles.
Select a compatibility role from the right pane and either:
- Click the arrow to the right of the name and select Delete, or
- From the Administration Console menu bar, select Resource > Delete.
Select one or more compatibility roles from the right pane and either:
- Click the arrow to the right of the name and select Delete, or
- From the Administration Console menu bar, select Resource > Delete.
Tip: Use Shift-click or Control-click to select multiple compatibility roles.
(Optional) Select Revoke role permissions to remove any users and roles currently granted to the compatibility role.

Note: A compatibility role cannot be deleted if any members are currently granted.
Click Yes.