January 15, 2009 at 2:42 pm
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. Could there be any reason why all the procedures lost their execute permissions . How do I back track this issue to find the cause of the loss of execute permissions on the stored procedures .
Thanks!!!
January 15, 2009 at 2:44 pm
I'm assuming that you mean that users lost their rights to execute procs. That can happen from a number of things. Someone may have been adding permissions to some user account, and didn't realize they were implicitly denying permissions on everything else. An account may have been modified so it lost membership in a group that gave it execution permissions. And so on.
SQL 2005 has a default trace running that, I think, has that kind of change logged in it. Check out traces in Books Online and you might find what you need in the trace files.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply