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 |
|
srinath
Starting Member
16 Posts |
 Posted - 2007-01-10 : 01:49:56
|
| HiWe have a permission issue with stored procedure..We gave db_datareader,db_datawrite and create proc permission to a user group, But what permission we need to give if we want to allow the users to modify any user defined stored procedure that is already existing...and we can't give ddl_admin as we don't want to give the permission of creating and dropping the tables to the users.Please let me know how can we achieve this.Thank You,Srinath. |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-01-10 : 04:41:07
|
| Sorry Should have tried it before opening my mouth-- RegardsTony The DBA |
 |
|
|
|
|
|
permission issue in altering stored procedure