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.
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.excitation.co.uk Blog: http://mscrmuk.blogspot.com/ "Sally" wrote: > 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.
