Re-Error logs

  • Ed7

    SSCrazy Eights

    Points: 8352

    I'm not hundred percent sure....I have a MS SQL Server 2012 in production.
    Recently, an application stopped working due to someone revoke the apps users READ/WRITE permission permissions.
    Then, I looked at the SQL Error logs and did not find any good information
    Questions:
    Where can I find log information that showed me a good information?

    Thanks in advance for helps.

  • NorthernSoul

    SSCertifiable

    Points: 6783

    Ed7 - Monday, February 19, 2018 3:25 PM

    I'm not hundred percent sure....I have a MS SQL Server 2012 in production.
    Recently, an application stopped working due to someone revoke the apps users READ/WRITE permission permissions.
    Then, I looked at the SQL Error logs and did not find any good information
    Questions:
    Where can I find log information that showed me a good information?

    Thanks in advance for helps.

    What information are you looking for? If you are looking for the user that revoked the permissions then unless you have set up some kind of auditing that that will not be logged.

    Thanks

  • subramaniam.chandrasekar

    SSCarpal Tunnel

    Points: 4108

    Ed7 - Monday, February 19, 2018 3:25 PM

    I'm not hundred percent sure....I have a MS SQL Server 2012 in production.
    Recently, an application stopped working due to someone revoke the apps users READ/WRITE permission permissions.
    Then, I looked at the SQL Error logs and did not find any good information
    Questions:
    Where can I find log information that showed me a good information?

    Thanks in advance for helps.

    Apologies, couldn't understand you.

  • Ed7

    SSCrazy Eights

    Points: 8352

    Is that any existing t-script that I can use to trace?

  • NorthernSoul

    SSCertifiable

    Points: 6783

    Ed7 - Tuesday, February 20, 2018 8:44 AM

    Is that any existing t-script that I can use to trace?

    No I'm afraid not. As I said it's not logged when a users permissions are changed. You would have to set up your own auditing to do that.

    Thanks

  • Ed7

    SSCrazy Eights

    Points: 8352

    I already setup SQL Audit.
    There are many pre-existing Audit Action Type.
    So far, I did not find one that can help me to monitor a user permission changed.

    Any suggestions?

  • Sue_H

    SSC Guru

    Points: 90194

    Permissions changes are captured by the default trace. If it happened recently, you can query the trace files.

    Sue

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

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