I want to create logins that are granted permission to access
- all user databases
view all definitions
select all records of all tables
To me it seems to be too much overhead to assign the login to each database and add it to a custom db role or to a default db role like db_datareader in each db.
Instead I tried to use a user defined server role.
But how can I assign the required permissions to a user-defined server role to allow view any definition and db_datareader for all dbs?
Is this even possible?