Hello!
I am using SQL Server 2005 and Infomaker 10.5. I created two views to retrieve data from msdb and TPAU respectively, granted select to impUsers(Type Database Role) on both views, then created a composite report using two stored procedures which call the above Views. I could retrieve information from SQL Server 2005 and Infomaker. However, I got the following error message when I try to run this report in Tessitura. Any help would be appreictaed!
Vicky
It works fine now after I changed my security setting. Is there other way I could do this?