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 |
|
igoro1975
Starting Member
7 Posts |
 Posted - 2002-08-26 : 02:37:53
|
| The question:You must modify a stored procedure in your database. Several users have been granted to execute this stored procedure.What statement would you execute to perform the modification without affecting the existing permissions?Thank you."I do not fear computers. I fear lack of them." - Isaac Asimov |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-26 : 04:19:26
|
| Best method is to script the SP with permissions.Amend this to the format you want.Save it in SourceSafe.Check out the script.Amend the script.Save it in source safeApply the amended script with permissions.This sounds like a test question though so it probably won't be the answer they are looking for.They probably expect something which you shouldn't do on a production database.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-26 : 08:27:59
|
| an ALTER statement would keep the existing permissions... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-26 : 10:39:55
|
| Yep - that's the one I was thinking of.You then lose the date of last update on the SP==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
I have a question