george sibbald (1/21/2014)
well - sysadmin - no only joking, don't do that 🙂that script will add the user to model as well, so all new databases would automatically get the user as model is the template for new databases.
Thanks, George. I will definitely not using sysadmin, but how about serveradmin, or processAdmin, by reading their definitions, I am not clear if they include all the permissions mentioned in the vendor script in the linked page in my original post.
Good catch, the last command -EXECUTE sp_MSforeachdb also add permission to new database.
This saves us the steps to add it.
But for this statement, EXECUTE sp_MSforeachdb, I understand it added the account to each database, but it didn't grant any permission to it, what is the usage of this command according to the doc?
Thanks