Skip to main content

SQL Server permissions

What are the minimum permissions required in SQL Server for users?

The following are the minimum permissions in SQL Server required for users if connecting using NT Authentication:

  • Permission needs to be provided on the instance level by your SQL Server Administrator. (Do not apply on the database level)

Tip: Permissions can be managed in SQL Server via Active Directory Group or by providing individual permissions per user.

Required Permissions:

  • Server Roles - dbcreator and public (for Backup and Restore)

  • User Mapping - dbowner and public - for the EvolutionCommon and each Payroll database

The same minimum permissions are required for SQL Server Authentication.

Did this answer your question?