Answered by:
The SELECT permission was denied on the object 'Audit'

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 PMModerator -
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 PMModerator -
The link helped me to solve the problem. Thanks!
Jani
Monday, April 27, 2015 2:02 PM