Dropping a role (Sybase Central)

Drop user-defined, user-extended, and compatibility roles. You cannot drop system roles.

Prerequisites

You must have administrative rights for the role being dropped.

The role being dropped must not own any database objects.

You can only drop a role if all dependent roles meet the minimum required number of administrative users with active passwords, as set by the min_role_admins database option.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Double-click Roles and select the role you want to drop.
Right-click the role and click Delete.

Results

The role is dropped and revoked from any user or role that had been granted the role. When you drop a role that can be administered by the MANAGE ROLES system privilege, the role is also revoked from the MANAGE ROLES system privilege.

Dropping a role (Sybase Central)

Task

See also