Online Documentation for SQL Manager for SQL server

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