User Security Requirements for MS Report Builder

User Security Requirements for MS Report Builder

Post by U2FsbH » Tue, 08 Jul 2008 11:31:05


Hi,

Currently running CRM4.0 (Upgraded from 3.0). Receiving the following error
when the "Run Report" command is used. Does someone have a list of all the
necessary security settings for a "non-admin" to build and run reports in the
MS Report Builder.

Semantic query execution failed. The SELECT permission was denied on the
object 'AccountBase', database 'Database Name", schema 'dbo'.
----------------------------
Query execution failed for data set 'dataSet'.
----------------------------
An error has occurred during report processing.
 
 
 

User Security Requirements for MS Report Builder

Post by RGF2aWQgSm » Tue, 08 Jul 2008 15:14:05

Judging from the error it looks like the fundamental problem is that the
report model was built on the underlying SQL tables, rather than the filtered
views. CRM users do not have permission on the base tables
--
David Jennaway - Microsoft Dynamics CRM MVP
Web: http://www.yqcomputer.com/
Blog: http://www.yqcomputer.com/