Granting Column Permissions

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

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 on which to set 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 on which to set 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, click Grant to grant access permissions for the selected column.
   You see the Grant Permission wizard.
9. Select the type of grantee:
   • Users
   • Groups
   • Roles
10. Select one or more grantees.
11. Select the types of permissions allowed for the selected grantees.
12. (Optional) Click With Grant Option. The grant option allows the specified users to grant object access permissions to other users.
13. (Optional) Click With predicated privileges.
    1. 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.
    2. (Optional) Enter a correlation name.
       The correlation name is an alias for referencing columns in the selected table within the where clause.
    3. (Optional) Enter a name for the predicate.
14. (Optional) Click Preview to see the SQL statements for your command.