Procedures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Procedures

Procedures

Rate Topic

Display Mode

Topic Options

Author

Message

sqlserver12345

Posted Thursday, January 15, 2009 2:42 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 01, 2013 12:42 PM
Points: 139, Visits: 447

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!!!

Post #637612

GSquared

Posted Thursday, January 15, 2009 2:44 PM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

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

Post #637614

« Prev Topic | Next Topic »

Permissions