SQL Data Level auditing template uses an account for the SQL Instance Credential and the credentials for the account specified must have the following permissions:
• Permission to open a connection to the targeted database.
• Read permissions on targeted tables and system tables.
• VIEW SERVER STATE permission
• SYSADMIN server role.
• For SQL 2012 and later: CONTROL SERVER permission and ensure that the specified database can be opened on the target server.