I am fixing an old progress 91a database, and need to check some reports build with ReportBuilder. It has worked swell until now. Suddenly it tells me that ReportBuilder cannot access the master table "NPSHTilbud" due to SQL error. Wrong rights for the table NPSHTilbud (978)
I have checked if the user has rights, and I am allowed to do a for each on the table. Is there some other setings I need to check?
I am not sure how ReportBuilder is working and I do not remember what progress version 91 was, but if that is a SQL then the table ("NPSHTilbud") should have grant for select.
The fact that you can do "for each" (4GL) does not mean that you can "select" (SQL). Here is how you can check if the table has a public grant to select in SQL
select * from sysprogress.systabauth where TBL = 'table name';
GRANTOR GRANTEE TBLOWNER TBL INS DEL UPD SEL EXE NDX ALT
ROOT PUBLIC PUB 'table name' y
Under "SEL" it should be "y" or "g"
ReportBuilder was/is not using SQL but 4GL engine, it all depends if you’re using the table interface or printrb/printrb2 and if you have any database connection override there… if not the database connection information that was saved in report definition (when the report was designed) is used.