Home Forums SQL Server 2008 Security (SS2K8) grant execute overrides user permissions RE: grant execute overrides user permissions
db042188
SSC Eights!
Points: 819
More actions
January 22, 2013 at 7:58 am
#1579647
thx Anthony. That didnt seem to work. I see my peer is a member of the deny data writer role. That makes me believe I set that up correctly. And yet he can execute (successfully) the update proc to which all he has is execute granted.