EMS logo

Produkt Navigation

SQL Manager for SQL Server

Unsere Partnerschaften

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Online Bedienungsanleitung

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.

 

menuGrantManager

 

 

 

 

Managing grants

 

To define grants on database objects:

  • select the Tools | Grant Manager main menu item, or use the corresponding btnGrantManager 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

 

 


See also:

Login Manager

Server Roles

User Editor

Role Editor

Login Editor