Revoking a role (Sybase Central)

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

Prerequisites

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.

Task

In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, click either Users or Roles and then click a specific user or role.

Choose one of the following options:

Administrative option

Action

Revoke the role from a user or role that has been granted this role.

Click the Grantees tab.
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.

Click the Roles tab.

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"

Tips

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

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

Click File » Save.

Results

The role is revoked from the specified user or role.

Revoking a role (Sybase Central)

Task

Tips

See also