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


Revoking a role (Sybase Central)

Revoke a role from a user, a user-extended role, or a user-defined role.


You must have administrative rights for the role to revoke user-defined roles. You must have MANAGE ROLES system privilege to revoke system roles.

You cannot revoke roles from the SYS role. You can revoke roles from other system roles, provided that these roles are not the default roles for the system role.

You can only revoke 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. In the left pane, click either Users or Roles and then click a specific user or role.

  3. Choose one of the following options:

    Administrative option Action
    Revoke the role from a user or role that has been granted this role.
    1. Click the Grantees tab.

    2. To revoke the role from a user or role, right-click the user or role and click Delete.

    Revoke exercise or administrative rights for a role.
    1. Click the Roles tab.

    2. Select a role, and then right-click and choose:

      • Revoke » Exercise rights. This is equivalent to executing the following statement:

        REVOKE ROLE "role-name" FROM "user/role-name"
      • Revoke » Administrative rights. This is equivalent to executing the following statement:

        REVOKE ADMIN OPTION FOR ROLE "role-name" FROM "user/role-name"

    To undo your changes, select one or more rows and click Edit » Undo.

    To turn the Legend on or off, click File » Show Legend.

  4. Click File » Save.


The role is revoked from the specified user or role.

 See also