Post reply

SQL 2008 Audit permission - Question

  • June 26, 2009 at 7:15 am

    #135465

    Hi, as per BOL:

    Principals with the VIEW AUDIT STATE permission have access to Audit catalog view. For example, sys.server_file_audits.

    Can some one help me how to assign VIEW AUDIT STATE permission to the user. I have a SQL job that connectes to db server with auditing ON and trying to read audit config information via same job using user with mimimum permission on db server.

    I tried to use like this but no success.

    GRANT VIEW AUDIT STATE TO [username].

    Any help pl?

    Thanks.

  • June 26, 2009 at 9:23 am

    #1016117

    as far as i have it: the principal has the VIEW SERVER STATE permission to use the any AUDIT DMV

    Maninder
    www.dbanation.com

  • June 26, 2009 at 11:40 am

    #1016214

    Thanks for reply.

    I have an AD user with READ on Master and VIEW SERVER STATE permission. When I select from sys.server_audit_files using that user, no records being returned. It works fine when I use sysadmin account. I think it requires something else too.

    BOL says VIEW AUDIT STATE is required to access catalog view but no success in using grant view audit state on [login].

    -jp

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

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