Revoking Column Permissions

Revoke table access permissions from users, groups, or roles.

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 > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Select the table for which to revoke column permissions.
  3. From the drop-down list, select Properties.
    You see the properties view for the table you selected.
  4. In the left pane, click Columns.
  5. Select the column from which to revoke permissions.
  6. From the drop-down list, select Properties.
    You see the properties window for the column you selected.
  7. In the left pane of the Properties view, click Permissions.
  8. In the right pane, select the grantee and 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 privilege are indicated by the letter "p" under a check mark.
  9. 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.
  10. (Optional) Click Preview to see the SQL statements for your command.
Related tasks
Granting Table Permissions
Revoking Table Permissions
Granting Column Permissions