May 26, 2010 at 8:42 am
I've got a procedure and permissions have changed twice on it in the last 2 days mysteriously. Whats the best way to determine when and how it is changing?
May 26, 2010 at 9:29 am
Are you using 2005 or 2008?
You might want to do a full inventory of who has what permissions to you database.
Permissions can also be dropped if an object like a SP is dropped and recreated in which case you can use the default trace that is already running as part of Server.
If this doesn't work I would setup a small light-weight trace for that specific object which is having the permission dropped as well as who is accessing the object..
Default Trace 2005
http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/
May 26, 2010 at 9:32 am
using sql 2000.
May 26, 2010 at 10:08 am
Using SQL 2000 there isn't a good way, other than a trace, to track this down. You won't see previous changes, but you can track future ones with a trace.
Very few people should be allowed to do this, so you might even want to trace those particular people.
May 26, 2010 at 11:30 am
Changed how? Are the permissions disappearing - or are they different from what you originally set?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply