Skip to main content

SQL Server permissions

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

Updated over 3 months ago

The following are the minimum permissions in SQL Server required for users if connecting via 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?