Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Apollois
Starting Member
49 Posts |
 Posted - 2004-03-06 : 18:25:15
|
| Is there a way to create a role that has EXECUTE permissions all SPs in DB, and will automatically include any new SPs that are created?Running:SS2K SP3aW2K AS SP3Best Regards,Jim |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-06 : 23:24:26
|
| Search the forums for isp_Grant_Permissions. It's a stored procedure that I wrote that grants permissions to objects. You can schedule it to run if you want it to do it "automatically" (although with some latency).Tara |
 |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-03-06 : 23:40:19
|
I include a GRANT statement in the template I use for all my stored procs. It's really easy to do things the way you want them the first time  Damian |
|
|
|
Apollois
Starting Member
49 Posts |
Posted - 2004-03-07 : 00:52:51
|
| Tara, thanks for sharing your GRANT SP. This will be very helpful.Damian, your approach is an excellent idea!Many thanks to both of you. You have solved my problem.Best Regards,Jim |
|
|
|
|
|
|
Stored Procedure Permissions