Use object access permissions to regulate the use of specific commands that access specific database objects.
Prerequisites
To grant or revoke predicated privileges, set the configuration parameter
enable predicate privileges to 1.
Task- In the left pane of the Administration Console, expand .
- Select the role on which to grant object permissions.
- From the drop-down list, select Properties.
You see the properties window for the role you selected.
- In the left pane, click Object Permissions.
- In the right pane, click Grant to grant permissions to
the listed role.
You see the Grand Permissions wizard.
- In the Welcome window, select an object type on which to grant permissions, then click
Next or Objects and Options.
- Select the object and options on which to grant permissions, then click
Next or Permission.
- Select the type of permissions to grant.
- (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.