April 18, 2007 at 9:57 am
I have a user who has public access only to our database. With public access they can not see any of our user tables, views or stored procedures. I created only two views and gave them Grant permission to select from these two views only. These are the only two views they have permission to and can select from.
The problem I am having is they can still select the system views and see stored procedures. Is there a way to deny them access to the system stored procedures and views as a group. Instead of selecting each (over 350) and denying select access?
I tried to give the user db_denydatareader but when I do that they can no longer select from the two views I created.
Any ideas?
April 18, 2007 at 10:15 am
I see your concern, but what good is the list of procedures if they can't gain access to them? I'd like to hear your thaughts on the process as a whole and why you want to limit them on that point too.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply