July 23, 2008 at 5:06 am
Is there a way to audit the users on SQL 2005 to show what permissions they have on the server or on a DB. I have a Server with around 20 DBs and 20-25 users and need to find out if any of the users have too high permissions.
Some hae DBowner on the Databases they own but want to make sure they cant do any thinf to server such as change maintenance plans etc.
Also is there an easy way to stop anyone making backups. as we have maintenance plans to backup full and t-logs, if someone creates an adhoc backup and deletes it will stop the Maintence plans backups restoring.
thanks
July 23, 2008 at 6:54 am
Can allways look at the syslogins table in Master database, should give you all that (not sure about the backup part of your question). Works in all versions up to and including SQL 2005, not sure about 2008.
July 23, 2008 at 8:07 am
i did this a few months ago, will have to find what i did
March 16, 2011 at 2:21 pm
I was looking for something like this too...does anyone already have a script they could post?
March 17, 2011 at 6:51 am
Here is a link to an excellent blog post about permissions
Bodsda
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply