Post reply

Database Auditing

  • August 22, 2019 at 12:00 am

    #3669587

    Comments posted to this topic are about the item Database Auditing

  • August 22, 2019 at 5:59 am

    #3673358

    Please note that to view the SQL Server audit log generated by the Security Audit you will need CONTROL SERVER permission ( or at least SA ).

    It was problematic for me, ( not a server admin , just a lowly database owner), so we had to had to use sys.fn_get_audit_file and put the results into a database\table.

    I think its a bit of an oversight really.

    I could create the Audit's, but could not view the log ( I believe the audits were correct, our sys admin said they were ).

    Thanks,

     

  • August 22, 2019 at 6:44 am

    #3673369

    Nice question, thanks Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

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

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