Post reply

Logs on SQL Database

  • June 24, 2009 at 1:38 am

    #201711

    Hi

    Is it advisable to log diffrenet logs on the sql database, i.e. access, errors, changes etc. The complimentary control is that all users have unique access profile.

    Additional pointers, asking the DBA he indicated that keeping logs will delay the response time of the database and who will check the logs since it will contain volumeous transactions. From the audit point of view its a risk not to log the reason being it will result in slow DB

    Regards

  • June 24, 2009 at 1:51 am

    #1014479

    It depends, what is your security policy in your company.

    If your manager wants to know every change in the database than you can implement the logging for changes. If you have the feeling that someone is changing objects in the database without informing you than it would be a good idea.

    Errors are already logged in SQL Servers but it depends on how much you want to log. Do you only want to log high severity logs or everything.

    If your company wants to know who logged in and when than you should implement it.

    So everything comes back to the security policy in your company.

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

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