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 |
|
SanjeevBaranwal
Starting Member
14 Posts |
 Posted - 2010-05-17 : 05:32:51
|
| Please suggest how to give permission to roles so that every user can execute and create the sp's but cannot drop it. |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2010-05-17 : 09:31:54
|
| GRANT EXECUTE ON OBJECT::dbname.uspStoredProcName TO User or Role;Use books on line (BOL). A treasure-trove of knowledge at your fingertips.Terry-- A word to the wise ain't necessary - it's the stupid ones that need the advice. -- Bill Cosby |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-05-23 : 11:50:24
|
To create SPs:Grant Create Procedure to [role] |
|
|
|
|
|
|
Denying Dropping SP's