I want to be able to give a user read permissions to all dbs on an instance. Including if a new database gets added to an instance. The only way I know how to do this is by mapping that user to a database specifically and then giving read . Is there any way to create a server role that would do this? Or any other alternative without having to give sysadmin or having to have someone map everytime a new db gets added.
