SQL Permissions for Fax Reporter

To add reporting permissions:

1. Add the domain account of the user that will run reports to SQL.
2. Add the db_datareader role for the user on the database.
3. Optional:  Add the execute permission for the user on the database.*

* The following reports require the execute permission:

• Outbound_Completed_Activity_Users
• Outbound_Activity_Users
• FaxLists_Detailed_CompletedFaxes
• FaxLists_Detailed_AllFaxes

To add the execute permission for the user on the database, open a new query in SQL Management Studio and execute the following:

USE DatabaseName;

GRANT EXECUTE TO "DomainUsername"

Reference:  Windows Permissions and Enterprise Fax Reporter