Hello!
We noticed a problem with our new multi-tenant IFD (SaaS) environment:
Reports did not run for other than default organization. The cause for the problem was found out after investigation.
One database function and one view is missing necessary permissions. The default organization has those but all others created with deployment administrator are missing those permissions to run reports. The database objects in question: fn_GetFormatStrings
and FilteredActivityPointer. Those should have 'select' permissions for CRMReaderRole and ReportingGroup.
Our environment had rollup 7 as a base and it was updated to rollup 10.
Does anyone know if the problem existed allready with rollup 7 or is it a new problem delivered us by new rollup 10? We did not have this problem with previous rollups.