For the db_datareader fixed database role: If I add a login to that role for a database, can it select from any table or view in the database, or is there some restriction based on schemas?
The reason I ask is that someone wants to review data in a database and I want to be sure they can select from all of the tables and views, regardless of the schema to which they belong.
If there is additional configuration needed beyond adding a login to db_datareader to accomplish this goal, please let me know.
Thanks for any help!
"I love spending twice as long and working twice as hard to get half as much done!" – Nobody ever.
"Operator! Give me the number for 911!" - Homer Simpson
"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"