[progress Communities] [progress Openedge Abl] Forum Post: Re: Driving Me Nuts - Cannot...

  • Thread starter Thread starter Dmitri Levin
  • Start date Start date
Status
Not open for further replies.
D

Dmitri Levin

Guest
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"

Continue reading...
 
Status
Not open for further replies.
Back
Top