Granting Privileges to a User

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

Prerequisites

See Enabling Granular Permissions.

Task
  1. In the Perspective Resources view, select the server on which the role resides, then click the drop-down arrow next to the server name and select Administration Console.
  2. In the left pane of the Administration Console, expand ASE Servers > Security > Users.
  3. Select a user for which to set privileges.
  4. From the drop-down list, select Properties.
    You see the properties window for the user you selected.
  5. In the left pane, click Privileges.
  6. In the right pane, click Grant.
    Only those privileges that are specific to the selected users and privileges that you are allowed to grant will appear in the Grant Privileges menu.
  7. Select one or more privilege from the Grant Privileges menu and click OK.
Related concepts
Enabling Granular Permissions
Related tasks
Revoking Privileges from a User