Grant system privileges to groups 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 group for which to set privileges.
- From the drop-down list, select Properties.
You see the properties window for the group you selected.
- In the left pane, click Privileges.
- In the right pane, click Grant.
Only those privileges that are specific to the selected role and privileges
that you are allowed to grant will appear in the Grant Privileges menu.
- Select the privilege from the Grant Privileges menu that you want to grant to the
group and click OK.
Only those privileges that are specific to groups and privileges that you are
allowed to grant will appear in the Grant Privileges menu.