4.0 SQL report permissions issue

jag333

I am experiencing an issue at a client site. The installation is 4.0/SQL. When running a report with their license on their SQL database, I get a message that htey don't have permission to read a table. When I switch to the developer's license and run the same report on their SQL database with the same login, the report runs fine. When I switch to my Native database (nonSQL), switch to THEIR license and run the same report, it runs just fine. Any ideas???

The table that is referenced in teh message is one to which they don't have permission, however, when I use their license on my database and run the same report, I don't get the message, even though they don't have permission. The data I'm using in both instances is the same.

WayneShi

Try to change on the report leve.
Open the report properties -> Permissions -> Type the table ID and select "Read Permission". \:D/

kine

Problem is this: In Native DB when you call ISEMPTY on table which you do not have permissions to and the table is empty, there is no problem. But if you call this on MS SQL, server need access this table to be able to say if the table is empty, but because you do not have permissions, you have error. Check where the problem is (enable debugger and run the process on client site) - you will see where is the problem and try to add something for testing right to thi table before you use it... And main rule - if user is using MS SQL, develop for him on MS SQL too...

jag333

Thanks everyone. The problem was indeed data related. There was data in a table that the license doesn't have permission to, even though the table wasn't needed. I created new data (demo) for the customer by clearing out the data to tables they don't have access to and everything is running fine now.