I have tried googling this but may well be using the wrong terms... permissions and the like aren't my strong point.
What I want to do is first create a role - eg 'Snr_Analyst' - with certain permissions to read everything, and alter particular schemas in a database. That bit I can do.
I also want that role to be able to grant read permissions on everything in that database to any other user, but not to grant any higher permissions.
Is this possible?
I'm currently using SQL Server 2014.