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?