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.
- In the left pane of the Administration Console, expand .
- Click the Name field of the user, then click the drop-down arrow and select
Properties.
- In the left pane, click Privileges.
- 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.
- Select one or more privileges from the Grant Privileges menu and
click OK.