Report is not running

Jun 19, 2013 at 7:41 AM
i receive this massage

An error has occurred during report processing.
Query execution failed for dataset 'DSFreigaben'.
The SELECT permission was denied on the object 'Entity', database 'SRMCC_MSCRM', schema 'MetadataSchema'
Jun 19, 2013 at 8:29 AM
This is by design. A standard CRM user without further permissions on specific database tables is not able to execute the report.

The user must have read permissions on the following tables in CRM database:
  • MetadataSchema.Entity
  • dbo.PrincipalObjectAccess
HTH / best regards,
Thomas
Jun 19, 2013 at 11:33 AM

Dear;

Thank you for your quick response,

Question, do I need to give this permission to every one want to view the report? or only for the one who have to install it?

Muaath M. Yousef

Description: C:\Users\muaath\AppData\Roaming\Microsoft\Signatures\SRMCC Signature\column.png

Saudi Readymix Concrete Co Ltd

Description: C:\Users\muaath\AppData\Roaming\Microsoft\Signatures\SRMCC Signature\twitter.png
Description: C:\Users\muaath\AppData\Roaming\Microsoft\Signatures\SRMCC Signature\facebook.png
Description: C:\Users\muaath\AppData\Roaming\Microsoft\Signatures\SRMCC Signature\linkedin.png

Senior Sales Engineer

PO Box 31839 Al-Khobar 31952

Kingdom of Saudi Arabia

Description: C:\Users\muaath\AppData\Roaming\Microsoft\Signatures\SRMCC Signature\logo.gif

T +966 3 8822 373 ext 2412

F +966 3 8822037

M +966 555 070 199

www.saudireadymix.com.sa

Jun 19, 2013 at 9:49 PM
You're welcome!

The report is targeting a technical audience. Currently it's designed as an instrument for debugging and tracing errors concerning CRM-internal sharing mechanisms.
So yes - you must grant the missing permissions to everyone who should be able to view the report.

Regards,
Thomas