EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

Database permissions

The Database Permissions tab allows you to define privileges on execution of statements within the specified database.


To edit the database permissions of a user/role, select the database using the Database panel of the Navigation bar, then select a user or role from the Privileges for list available within the Navigation bar or toolbar.


Grant Manager - Database permissions



Right-click a cell next to the required statement to grant its execution privilege to the selected user or role. The context menu of a cell contains possible permissions that can be granted:

  • Grant
  • Grant with Grant Option
  • Revoke (removes a previously granted permission)
  • Deny
  • Grant All
  • Grant All with Grant Option
  • Revoke All
  • Deny All



See also:

Using Navigation bar, Toolbar and context menu

Setting object permissions

Managing column permissions

Filtering objects in list

Viewing effective permissions