Grant permission to all existing databases to a user

First make sure you pick the right role: https://msdn.microsoft.com/en-us/library/ms189121.aspx

For existing databases use this

 

For future ones use this

Leave a Reply

Your email address will not be published. Required fields are marked *