Deleting a Standalone Role

Delete a standalone role from the database.

Prerequisites

Database Version	Role-Based Standalone Role Privileges
SAP Sybase IQ 15.3 and 15.4	Not supported.
SAP Sybase IQ 16.0	You must have one of: Administrative rights over the role being deleted MANAGE ROLES system privilege if the role being deleted has a global role administrator

The SAP Sybase IQ resource is authenticated and running.
The selected resource supports role-based security
The standalone role being deleted does not own any database objects and is not currently connected to the database.

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 Standalone Roles.
Select one or more 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 standalone roles.
In the Confirm Delete dialog box, click Revoke role permissions.
Click Yes to complete the deletion.