I am upgrading my Sitecore isntance from 9.0 initial to update-1. In this process I had to deploy the databases for EXM (exm.master and messaging) as that is new in this version. I used the dacpac's from the upgrade package as mentioned in the guide.

Although not mentioned in the upgrade guide, I added the sql user (used for the other databases) to these and added:

  • read/write rights on both databases
  • execute rights on the exm.master database

This seems to work now.. but does anybody know if this is correct? What are the minimal rights that are needed for the user in my connection string?

1 Answer 1


For the EXM Master and Messaging Databases specifically, the only permissions you must have are read/write permissions and EXECUTE on both databases. While there are no stored procedures in those databases that would require the EXECUTE permission, there . Additionally, I am not aware of any TRUNCATE needs.

Alternatively, for things like the Analytics Databases, the Sitecore DB user does need EXECUTE and TRUNCATE permissions because things like Rebuilding the Reporting Database uses stored procedures and truncation.

But for EXM specifically, the read/write permissions (which should give you the standard CRUD operations) and EXECUTE should be enough.

  • On my exm.master I needed to add execute right to get rid of errors in the logs..
    – Gatogordo
    Jan 9, 2018 at 16:18
  • What were the errors? Jan 9, 2018 at 16:19
  • Failed to remove obsolete sessions - The EXECUTE permission was denied on the object 'SessionIDs', database '...Exm.master'
    – Gatogordo
    Jan 9, 2018 at 16:21
  • I have the same error as @Gatogordo. Is there a solution to this?
    – Tillito
    Nov 19, 2019 at 10:10
  • Add the execute permissions, that should solve it
    – Gatogordo
    Nov 19, 2019 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.