Results 1 to 4 of 4

Thread: Server auditing

  1. #1
    Guest

    Server auditing

    Hi all:

    I need some help with this. I have a development server and all the developers log in as sa. Lately test data has been mysteriously deleted from selected tables. I need to track the time that the activity is taking place so I can figure out who might be playing this little game. Can anyone suggest what I can do to find this out? Your quick response will be appreciated.


  2. #2
    Stephen Wynkoop Guest

    Server auditing (reply)

    You`ll think this is a shameless plug, but it isn`t. Check out SQL Auditor from dbSecure. you`ll get a ton of informaion on logins and security levels and suggestions for managing, controlling and so forth against these resources.

    If you`re interested, they (dbSecure) do have a discussion forum here on swynk that will let you ask questions, etc. and find out more about their software. I`ve used it and it`s really comprehensive. Just open the 3rd Pty Help menu to the left and go to SQL Auditor.

    From there, you could set up triggers and dump the rows to a different table when deleted, track the user, etc.

    HTH
    SW

    On 9/23/98 9:42:23 AM, wrote:
    > Hi all:

    I need some help with this. I have a development server and all
    > the developers log in as sa. Lately test data has been mysteriously
    > deleted from selected tables. I need to track the time that the activity
    > is taking place so I can figure out who might be playing this little game.
    > Can anyone suggest what I can do to find this out? Your quick response
    > will be appreciated.


  3. #3
    VK Guest

    Server auditing (reply)

    MSSQL Server has its own utility called - SQL Trace or use xp_sqltrace.
    Both allow database administrators and application developers to monitor and record database activity. Multiple instances of xp_sqltrace can be run simultaneously.

    VK.

  4. #4
    Guest

    Server auditing (reply)

    Thanks. I requested an eval copy.

    On 9/23/98 9:53:14 AM, Stephen Wynkoop wrote:
    > You`ll think this is a shameless plug, but it isn`t. Check out SQL Auditor
    > from dbSecure. you`ll get a ton of informaion on logins and security
    > levels and suggestions for managing, controlling and so forth against these
    > resources.

    If you`re interested, they (dbSecure) do have a discussion
    > forum here on swynk that will let you ask questions, etc. and find out more
    > about their software. I`ve used it and it`s really comprehensive. Just
    > open the 3rd Pty Help menu to the left and go to SQL Auditor.

    From
    > there, you could set up triggers and dump the rows to a different table
    > when deleted, track the user, etc.

    HTH
    SW

    On 9/23/98 9:42:23 AM,
    > wrote:
    > Hi all:

    I need some help with this. I have a development
    > server and all
    > the developers log in as sa. Lately test data has been
    > mysteriously
    > deleted from selected tables. I need to track the time
    > that the activity
    > is taking place so I can figure out who might be
    > playing this little game.
    > Can anyone suggest what I can do to find
    > this out? Your quick response
    > will be appreciated.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •