In SQL Server, I have a user in a particular database and I've been asked to grant them access to all of the non-system views of the database only. I believe this can be done by editing securables of type view and granting select on each one, but there are many, many views. Is there a more efficient way to accomplish this?
There is no syntax such as
to generate a script to run to
I took another approach in my case. This is what I did:
The good thing is that the new user will not have access to the tables, he won't even be able to see the tables.
I hope it helps.