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?