Post reply

SQL logs

  • March 29, 2010 at 5:12 am

    #72831

    Hi,

    The databases of my application is granted access by GeoTelAdmin. Now not sure the permission was un-checked and application started throwing errors. After checking we could find SQL permissions of GeoTelAdmin bein unchecked. After selecting the option and restart SQL services, application started working fine.

    Any idea as which logs to collect to know when and who un-checked the permission. Is it User or application which did that?

    Thanks,

    Hari.

  • March 29, 2010 at 6:05 am

    #1141354

    Please refer to Security audit events in profile.

    Not sure how feasible is it.

    http://msdn.microsoft.com/en-us/library/ms191148.aspx

    "Audit Schema Object GDR Event Class"

  • March 29, 2010 at 9:03 am

    #1141494

    SQL doesn't keep historical logs for this kind of thing by default. If you did not have a trace running at the time, there's no way to find out who did this and when

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 30, 2010 at 1:19 am

    #1141981

    Thanks for the replies 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

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