Minimum permissions needed to use System Database

There are two different user authentication types that can be used with a BarTender System Database:

• Windows authentication
• SQL Server authentication

Windows authentication connects to the BarTender database using the Windows user account that is currently logged in.  In this method, SQL does not ask for a password; authentication is handled by Windows alone. You can use an active directory users or groups for easier management.

SQL Server authentication uses logins that are created directly on the SQL server.  These logins are not based on Windows user credentials.

There are minimum permissions required to connect to a BarTender System Database (additional permissions will be required for administration):

• CONNECT
• DELETE
• EXECUTE
• INSERT
• SELECT
• UPDATE

For more information, refer to the Administration Console technical document or Options for configuring BarTender System Database permissions.

Additional resources

When working with a system database, there are a number of moving parts both within SQL and in the BarTender Suite. The following resources can help determine which type of authentication is right for you and what extra permissions you might need with administration.

Authentication

• Which authentication method should I use to connect to the BarTender System Database?
• Options for configuring BarTender System Database permissions
• BarTender Services and Permissions

Administration

• What are the minimum permissions required to perform Administrative Tasks for the System Database?
• Technical Document - Administration Console