We have a database with over 1000 tables. I need to create a role that allows read only on all tables, as well as write access to two specific tables.
I was messing around with database roles, but whenever I went to add the tables, I had to hand select all 1000... is there a better way to do this?
Not the answer you're looking for? Browse other questions tagged sql-server-2012 security role or ask your own question.