October 15, 2008 at 1:56 pm
Hi everyone, I have a little problem with the public role from my server.
I have a db and a user that has only the public role assign to it. The user has privileges to execute a sp, the sp makes a select to a table which the user is not supposed to have access to. But when the user executes the sp, he gets access to the table, do you guys know which is the permit I have to remove from this role so not even the sp has access to the table?
Thanks in advance.
October 15, 2008 at 2:12 pm
This is a duplicate post. Please do not cross-post, it just annoys us and gets in our way.
Please direct all replies to http://www.sqlservercentral.com/Forums/FindPost586437.aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply