locked
The SELECT permission was denied on the object 'Audit' RRS feed

  • Question

  • Hi,

    I wrote a Reporting Service report which reads Audit view from CRM organization database. It works fine when runned in Visual Studio in SQL server but when I load the RDL file into CRM and try to run it I got "Reporting Error" and the reason is "The SELECT permission was denied on the object 'Audit'". I have System administrator rights. Is there something special whit Audit view user rights?

    Jani

    Monday, April 27, 2015 7:42 AM

Answers

  • Crm users are granted SELECT permission in SQL on the CRM filtered views, but there is no filtered view on the Audit entity. From your error, it looks like you're querying the underlying 'Audit' view, on which Crm users would not have permission (I expect it works in Visual Studio because you're running the report as a user with dbo rights on the MSCRM database)

    The simplest resolution is to grant SELECT permission on the Audit view to those users who should run the report, though note that strictly this is unsupported, as is querying the Audit view directly


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by JokiJani Monday, April 27, 2015 2:02 PM
    Monday, April 27, 2015 12:59 PM
    Moderator
  • Hi,

    Have a look at the below given link,

    Check whether it helps!!!

    http://kelvinshen.blogspot.com/2012/02/crm-2011-auditing-report.html

    Thanks,

    Prasad

    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    • Marked as answer by JokiJani Monday, April 27, 2015 2:02 PM
    Monday, April 27, 2015 8:36 AM

All replies

  • Hi,

    Have a look at the below given link,

    Check whether it helps!!!

    http://kelvinshen.blogspot.com/2012/02/crm-2011-auditing-report.html

    Thanks,

    Prasad

    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

    • Marked as answer by JokiJani Monday, April 27, 2015 2:02 PM
    Monday, April 27, 2015 8:36 AM
  • Crm users are granted SELECT permission in SQL on the CRM filtered views, but there is no filtered view on the Audit entity. From your error, it looks like you're querying the underlying 'Audit' view, on which Crm users would not have permission (I expect it works in Visual Studio because you're running the report as a user with dbo rights on the MSCRM database)

    The simplest resolution is to grant SELECT permission on the Audit view to those users who should run the report, though note that strictly this is unsupported, as is querying the Audit view directly


    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by JokiJani Monday, April 27, 2015 2:02 PM
    Monday, April 27, 2015 12:59 PM
    Moderator
  • The link helped me to solve the problem. Thanks!

    Jani

    Monday, April 27, 2015 2:02 PM