ramyours2003 (3/6/2014)
i have 100 + of tables want to provide select permissions to all the tables which starts with A in a database with dbo is schema , how can i provide ?
Overkill would to provide SELECT on the dbo schema or assign db_datareader permission.
You could write a query to pick up all table names and generate the grant statement.
However, why not just create a database role with grant on all existing required tables and when the user adds a new table, add it to the role.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉