Users Cannot View Reports That I (=creator) Can

Hello colleagues,

I am trying to create some reports in VS.NET for our Microsoft CRM3.0.

I am using a SQL query like this:

SELECT CRMAF_Account.Name, CRMAF_Account.primarycontactidName, CRMAF_Account.address1_line1, CRMAF_Account.address1_line2, CRMAF_Account.address1_city, ActivityPointer.scheduledstart, ActivityPointer.subject, ActivityPointer.description
FROM ActivityPointer, FilteredAccount CRMAF_Account INNER JOIN FilteredSystemUser FSU ON CRMAF_Account.ownerid = FSU.systemuserid
WHERE ActivityPointer.regardingobjectid = CRMAF_Account.accountID AND FSU.Domainname = SYSTEM_USER
ORDER BY Datum DESC

When I run this query, I get the desired result (I am the database dbo), but when any user tries doing the same, they get an error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set '[DatabaseName]'. (rsErrorExecutingCommand) Get Online Help

SELECT permission denied on object 'ActivityPointer', database '[DatabaseName]', owner 'dbo'.

I desperately need to know which user rights are missing and where are they missing - I do not suppose that the rights are expected to be assigned directly to the database tables

Any quick help would be highly appreciated. I would also appreciate any articles with examples how to use parameters, filters and subreports.

Thank you very much.

Marek Hlavac.