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 |
|
metro17
Starting Member
8 Posts |
 Posted - 2009-02-02 : 14:09:08
|
| I have come across in my sql server database that all of a sudden all of the stored procedures lost execute permissions and as a result the resulting front end application did not open and it crashed. I'm mean that users lost their rights to execute procs. Could there be any generic/specific reason reason why all the procedures lost their execute permissions . I tried using the trace on sql profiler . How do I back track this issue to find the cause of the loss of execute permissions on the stored procedures . Any inbuilt procedures etc.. I do not want to download any 3rd party tools.Thank you!!! |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-02 : 14:19:32
|
| Did you upgrade the stored procedures recently and use drop and then create? Dropping an object drops the subsequent permissions. That's the easiest explanation.Mike"oh, that monkey is going to pay" |
 |
|
|
metro17
Starting Member
8 Posts |
Posted - 2009-02-02 : 15:51:45
|
I did not understand when you said 'upgrade stored procedures ' . Well dropping an object ...No , did not drop any object .Thanksquote:
Originally posted by mfemenel
Did you upgrade the stored procedures recently and use drop and then create? Dropping an object drops the subsequent permissions. That's the easiest explanation.Mike"oh, that monkey is going to pay"
|
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-02-02 : 16:11:15
|
| I suppose instead of "upgrade" I should have said "modify" as in deploy new versions of existing SP's.Mike"oh, that monkey is going to pay" |
|
|
|
metro17
Starting Member
8 Posts |
Posted - 2009-02-02 : 17:51:48
|
| But how do I get to the root of this issue ? Any suggestion ? Thank you |
|
|
|
|
|
|
Procedures permissions