May 25, 2010 at 11:50 am
I have given a user group read only permissions to a db, however I want to limit them to only the views I create within the database, I don't want them to be able to access the tables. How do I go about doing this?
Thanks in advance!!
May 25, 2010 at 1:48 pm
You have to remove them from the db_datareader role which grants read access to all objects (tables and views). Then, you have to explicitly grant read access to each view.
Create a role and grant the role access to select from each view, then add your users to the role.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
May 26, 2010 at 10:04 am
Worked perfectly! Thanks for your reply!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply