I got the 'Select permission denied' error for some of my tables in a database.
MS SQL Server 2012, setting
Select Permission on 1 table is easy. I just right click on the
table > Properties > Permissions > Select the User/Role and tick the
Select Permission in the 'Explicit' tab below.
But I want to do that for over a 100 tables. Is there a better way to do it?