Granting Column Permissions

Grant column access permission to users, groups, or roles.


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

  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. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Columns.
  4. Click the Name field of the column, then click the drop-down arrow and select Properties.
  5. In the left pane, click Permissions.
  6. In the right pane, click Grant to grant access permissions for the selected column.
    You see the Grant Permission wizard.
  7. On the Welcome screen, select the type of grantee:
    • Users
    • Groups
    • Roles
  8. On the Grantee screen, select one or more grantees.
  9. On the Permission screen:
    1. Select the types of permissions allowed for the selected grantees.
      Select Look at information in a table or view
      Update Update rows in a table or view. This may be granted on a set of columns in a table only
      References Create indexes on a table, and to create foreign keys that reference a table
    2. (Optional) Click With grant option to allow the specified users to grant object access permissions to other users.
    3. (Optional) Click With predicated privileges.
    4. Enter the where search conditions.
      The search conditions act as a row filter, with the where clause specified on select, update, or delete. Search conditions can use all syntax allowed in a generic where clause.
    5. (Optional) Enter a correlation name.
      The correlation name is an alias for referencing columns in the selected table within the where clause.
    6. (Optional) Enter a name for the predicate.
  10. (Optional) Click Preview to see the SQL statements for your command.
Related tasks
Granting Table Permissions
Revoking Table Permissions
Revoking Column Permissions