RonMexico (12/5/2016)
Sue - I must not be setting it up correctly when trying to follow your advice. What permissions do I grant at the database level that won't apply to all schemas? For example, I grant alter permission to the role at the database level and they can also create tables in the dbo schema which I do not want.
You don't grant at the database level. The role is granted permissions at each schema level
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉