Granting Permissions on Precomputed Result Sets

Grant permission on precomputed result sets for users, groups, and roles.

  1. In the Administration Console view, select ASE Servers > Compiled Objects > Precomputed Result Sets
  2. Click the Name field of the precomputed result set, then click the drop-down arrow and select Properties > Permissions.
  3. Click Grant
  4. On the Welcome tab, select whether you are granting permissions for a user, group, or role.
  5. Click Next.
  6. On the Grantee page, indicate the user to whom you are granting permissions.
  7. Click Next.
  8. On the Columns and Options page, select the columns for which to grant permissions.
  9. Click Next.
  10. The Permissions tab shows which actions you can perform. Select the actions for which to grant permissions:
    • If you select all the columns, the Permissions page shows all actions.
    • If you select a subset of columns, the Permissions page shows only the actions permissible for these columns.
  11. Click Next.
  12. On the Summary page, review your choices.
  13. Select Finish to grant these permissions.
Related tasks
Granting Precomputed Result Set Permissions to a Specific User
Revoking Precomputed Result Set Permissions from a Specific User
Revoking Permissions on Precomputed Result Sets