Granting Object Permissions to a Role

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
  1. In the left pane of the Administration Console, expand ASE Servers > Security > Roles.
  2. Click the Name field of the role, then click the drop-down arrow and select Properties.
  3. In the left pane, click Object Permissions.
  4. In the right pane, click Grant to grant permissions to the listed role.
  5. In the Welcome window, select an object type on which to grant permissions, then click Next or Objects and Options.
  6. Select the object and options on which to grant permissions, then click Next or Permission.
  7. Select the type of permissions to grant.
  8. (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.
  9. (Optional) Click Preview to see the SQL statements for your command.
Related tasks
Setting Command Permissions for a Role
Managing Mutually Exclusive Roles
Revoking Object Permission from a Role