Object Permission Changes

  • SQL Server 2000 SP4

    I have a server that has a role. The local group that populated that role was inadvertently removed by a DBA or Admin within the last few weeks. Is this information stored anywhere in a logfile? I looked through the error logs to no avail (obviously).

    If the answer to my question is no, is there a way to set this up without third-party software?

  • John, I am not sure about where to find it, but I am actually in the process of writing a group of sp's to look at all server and database roles and the logins associated with each etc.  Based on that I am going to create audits to see when any new logins are added as well as generating a script that will run weekly to backup the logins associated with those roles.  I was concerned with running into very issue you did.  I would be happy to share those with you when I am done if you are interested.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply