Manage login account privileges by granting command permissions to a selected role.
- In the Perspective Resources view, select the servers on which the roles have been defined, then select Administration Console.
- Select .
- Select one or more roles on which to set command permissions, then select Properties.
- From the Roles Properties window, select Command Permissions.
- Select a database on which the selected roles will have permission to execute commands.
- To grant command permissions for the selected roles, click Grant and select one or more commands.
- To revoke command permissions for the selected roles, select a command and click Revoke.