Post reply

SQL Server Audit Permissions

  • June 29, 2016 at 3:09 am

    #400338

    Morning folks,

    I have an app user that needs to access/read some audit logs. I have set up a view that reads in the audit log - to make the job easier.

    However, it looks from the outset that the permission required to use the view (and the underlying fn_get_audit_file) is the Control Server permission.

    Short of importing all of the data, is there a way that I can give a pleb application account permission to read the data?

    Thanks,

    James

  • June 29, 2016 at 8:00 am

    #1887633

    You could create a SQL account, give it the necessary permissions and use it in your connectionstring.

    Alternatively, create a stored procedure with EXECUTE AS. Give execute permissions on the SP.

  • June 29, 2016 at 9:30 am

    #1887667

    Hmm, I've tried that and need to set IMPERSONATE AS in order to use it - and giving server control isn't an option in this case!

    Sadly, at this point, I suspect it isn't possible without granting these elevated permissions in one way or another.

    Think i'm going to have to import to a table 🙁

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

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