Unanswered: Is there a way to grant to multiple tables?
Is there a way to grant SELECT to multiple tables but not whole database in TSQL of MS SQL? ex: grant to table1, table 9, table100, ... rather then grant to whole database database by giving him/her db_datareader.
I'm trying to limit what a certain account can select on.
...repeat for other tables
The above work...but too tiring after 50 tables
I already test try:
on Table1, Table9, Table100
* but it doesn't like that...syntax error.
Any ideas? Or are there any better way to deal with this? Thanks.