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 |
|
Gary80
Starting Member
1 Post |
 Posted - 2014-05-28 : 06:14:36
|
| I am facing a problem and don't know what the problem is (or if there is a problem). About a week ago a user requested that I create a Stored Procedure for a utility that extracts and update data from Excel. I granted EXECUTE permissions on the Stored Procedure and all worked since last week till this morning when the User received a permissions error. When I troubleshoot the issue I found out that the EXECUTE permissions are gone. What could be taking off these rights?Progress is not so much about speed but rather direction. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-06-12 : 19:34:07
|
Sounds like someone revoked the permission. If you need to detect changes to permissions, it is possible to create a database level (not object level) trigger to detect rights and role assignment events. It's also possible to create a server level trigger to monitor the same.
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
ScottPletcher
Aged Yak Warrior
550 Posts |
Posted - 2014-06-24 : 17:35:24
|
| I suspect someone might have dropped and recreated the object. The drop would discard all existing permissions. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-24 : 17:50:35
|
Some permissions are reset when applying a service pack or CU.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
EXECUTE permission on Stored Procedure