Grant Manager
Grant Manager allows you to set the user access grants for certain database objects: schemas, tables, views, procedures, synonyms, aggregates, XML schema collections, assemblies, etc.
'Global' user privileges define the user access rights to all the database objects on the server. Granting privileges on the selected database objects allows a user to perform the defined operation over the selected objects.
To open Grant Manager, select the Tools | Grant Manager main menu item.
- Using Navigation bar, Toolbar and context menu
- Setting object permissions
- Managing column permissions
- Filtering objects in list
- Setting database permissions
- Viewing effective permissions
To define grants on database objects:
-
select the Tools | Grant Manager main menu item, or use the corresponding
toolbar button to open Grant Manager;
- select the object type using the drop-down list on the toolbar;
- select a User or Role from the Privileges for pane of the Navigation bar;
- edit user/role privileges using Grant Manager
or
- right-click an object within the Users/Roles node in DB Explorer and select the Grants for <object_name> context menu item;
- edit user/role privileges using Grant Manager
|
Availability: |
|
|
Full version (for Windows) |
Yes |
|
Lite version (for Windows) |
Yes |
|
Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page. |
|
|
See also: |