Grant system privileges to users at the server or database
level.
Prerequisites
See Enabling Granular Permissions.
- 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.
- In the left pane of the Administration Console, expand .
- Select a user for which to set privileges.
- From the drop-down list, select Properties.
You see the properties window for the user you selected.
- 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 will appear in the Grant Privileges
menu.
- Select one or more privilege from the Grant Privileges menu and click
OK.