June 7, 2007 at 1:05 pm
Where's the GUI to grant the public role execute permissions on all my stored procs? I've a few dozen and I'd really rather not click on each SP twice in Public's Securables list
June 7, 2007 at 1:12 pm
There isn't one to my knowledge. From the GUI you can either go into the properties of the role or the properties of the object.
You sure you want to do that, however? Usually comes around to bite you in my experience...
June 7, 2007 at 1:15 pm
aspnet user has to be able to execute SPs somehow...
June 7, 2007 at 1:29 pm
Why not grant to the specific ASPNET user then? Or use impersonation in your application?
I mean, do what you want, but it's usually a pretty bad security practice to go around granting execute on everything to everyone. Someone somehow gets an account on that sql server and you've already pre-approved them to do whatever they want...
June 7, 2007 at 1:32 pm
I did, in fact just do that. ASPNET is exec'ing fine now. Public's still locked out.
June 8, 2007 at 12:25 pm
I was actually having the opposite problem. I posted a script here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=359&messageid=372467
The script is designed to deny public permissions, but by changing "deny" to "grant," you should be able to grant permissions to everything.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply