Granting Privileges to a User

Grant system privileges to users at the server or database level.

Prerequisites

To grant or revoke privileges, set the configuration parameter enable granular permissions to 1.

Task
  1. In the left pane of the Administration Console, expand ASE Servers > Security > Users.
  2. Click the Name field of the user, then click the drop-down arrow and select Properties.
  3. In the left pane, click Privileges.
  4. In the right pane, click Grant.
    Only those privileges that are specific to the selected users and privileges that you are allowed to grant appear in the Grant Privileges menu.
  5. Select one or more privileges from the Grant Privileges menu and click OK.
Related concepts
Enabling Granular Permissions
Related tasks
Revoking Privileges from a User