Post reply

Re-Error logs

  • February 19, 2018 at 3:25 pm

    #329419

    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.

  • February 20, 2018 at 1:02 am

    #1980389

    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

  • February 20, 2018 at 6:22 am

    #1980436

    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.

  • February 20, 2018 at 8:44 am

    #1980474

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

  • February 20, 2018 at 8:46 am

    #1980476

    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

  • February 20, 2018 at 9:01 am

    #1980479

    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?

  • February 20, 2018 at 10:33 am

    #1980494

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

    Sue

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

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