Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » User and database security » User security (roles and privileges) » Roles


Dropping a role (Sybase Central)

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


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.

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Double-click Roles and select the role you want to drop.

  3. Right-click the role and click Delete.


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.

 See also