Post reply

security of audit.

  • August 24, 2011 at 1:56 am

    #242751

    Can some one help me in trying to find out who removed access to a certain Database for a specific user?

  • August 24, 2011 at 2:03 am

    #1372391

    Got any auditing or DDL triggers in place?

    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

  • August 24, 2011 at 2:05 am

    #1372392

    No,

    i do not have.

  • August 24, 2011 at 2:10 am

    #1372394

    Without some custom audit, that information is not stored anywhere.

    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

  • August 24, 2011 at 3:11 am

    #1372421

    If you have added triggers you can check all that.

    ----------------------------------------------------------------
    **"There is only one difference between dream and aim. Dream requires Soundless sleep to see…Where as Aim Requires Sleepless Efforts to Achieve":-) **

  • August 24, 2011 at 3:30 am

    #1372431

    My login auditing setting is set to audit failed login.

  • August 24, 2011 at 6:46 am

    #1372512

    That's just auditing login failures. Changes to security settings are not logged unless you have a trace or some form of trigger.

    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

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

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