Grant column access permission to
users, groups, or roles.
Prerequisites
To grant or revoke predicated privileges, set the configuration parameter
enable predicate privileges to 1.
- In the left pane of the Administration Console, expand , then choose one of the following:
- Select the table on which to set column permissions.
- From the drop-down list, select Properties.
You see the properties view for the table you selected.
- In the left pane, click Columns.
- Select the column on which to set permissions.
- From the drop-down list, select Properties.
You see the properties window for the column you
selected.
- In the left pane of the Properties view, click Permissions.
- In the right pane, click Grant to grant access
permissions for the selected column.
You see the Grant Permission wizard.
- Select the type of grantee:
- Select one or more grantees.
- Select the types of permissions allowed for the selected grantees.
- (Optional) Click With Grant Option. The grant option allows
the specified users to grant object access permissions to other users.
- (Optional) Click With predicated privileges.
- 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.
- (Optional) Enter a correlation name.
The correlation name is an alias for referencing columns in the selected table
within the where clause.
- (Optional) Enter a name for the predicate.
- (Optional) Click Preview to see the SQL statements for
your command.