Revoking Object Permission from a Role

Revoke database object permissions from a role.

Prerequisites

To grant or revoke predicated privileges, set the configuration parameter enable predicate privileges to 1.

Task
  1. In the left pane of the Administration Console, expand ASE Servers > Security > Roles.
  2. Click the Name field of the role, then click the drop-down arrow and select Properties.
  3. In the left pane, click Object Permissions.
  4. In the right pane, click the Database drop-down list and select the database on which you want to revoke permissions from the role.
  5. In the right pane, click the drop-down list and select an object type to filter the objects.
  6. Select the object from which to revoke permission, then click Revoke.
    In the Revoke Permissions window, each type of permission is listed. Currently granted permissions are indicated by a check mark. Permissions with predicated privileges are indicated by the letter "p" under a check mark.
  7. Choose one of:
    • Click Revoke all permission to revoke all permissions shown in the Revoke Permissions window.
    • Click individual cells to revoke the currently granted permissions. The cell changes to show an "x," indicating that the permission type is no longer granted.
    • Click Revoke all permission with predicate to revoke all permissions with a predicate shown in the Revoke Permissions window.
    Click Predicate to see details of the predicate search condition.
  8. (Optional) Click Preview to see the SQL statements for your command.
Related tasks
Setting Command Permissions for a Role
Managing Mutually Exclusive Roles
Granting Object Permissions to a Role