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
Requires 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, select
IQ Servers
>
Security
>
Role-Based
>
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.
Parent topic:
Standalone Roles
Related concepts
Manage Standalone Role Administrators
Manage Global Role Administrators of a Standalone Role
Related tasks
Creating a Standalone Role
Adding a Grantee to a Standalone Role
Changing a Grantee's Administrative Rights on a Standalone Role
Removing a Grantee from a Standalone Role
Adding a Role to a Standalone Role
Changing Administrative Rights on an Underlying Role of a Standalone Role
Removing a Role from a Standalone Role
Adding a System Privilege to a Standalone Role
Changing Administrative Rights on a Privilege Granted to a Standalone Role
Removing a System Privilege from a Standalone Role
Generating Standalone Role DDL Commands
Viewing or Modifying Role-Based Standalone Role Properties
Authenticating a Login Account for a Managed Resource
Related reference
Role-Based Standalone Role Privilege Summary
Created May 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com