No select permission

Apparaently this may look very novice querry but hold ... A user xxx has select,insert,update permission, connected to database and runs some app program every day. The program shows no select permission error 272 when executed thru .4ge Now if you run ISQL (from user login session) and select the same table it does select the table. What can be wrong? any guess Mukund Shevkar

When it doubt, double check. 1. Using dbaccess, select table:info - then choose the table and choose permissions. Confirm that the user has select permissions. 2. If you like to look deeper, do a select on systabauth; you might want to do a join with systables since systabauth contains only the tabid (it also contains the granter, grantee, and the actual permissions). Also, would be helpful if you supplied the code fragment within the 4GL program that's having a problem. I get the feeling that there is a [important] piece of the puzzle missing .... "Shevkar, Mukund" wrote: > Apparaently this may look very novice querry but hold ... > A user xxx has select,insert,update permission, connected to database > and runs some app program every day. > The program shows no select permission error 272 when executed thru .4ge > > Now if you run ISQL (from user login session) and select the same table it > does select the table. > > What can be wrong? any guess > > Mukund Shevkar

Shevkar, Mukund wrote: > > Apparaently this may look very novice querry but hold ... > A user xxx has select,insert,update permission, connected to database > and runs some app program every day. > The program shows no select permission error 272 when executed thru .4ge > > Now if you run ISQL (from user login session) and select the same table it > does select the table. > > What can be wrong? any guess Just a shot in the dark but is it possible that someone made the .4ge an SUID program in which case it would run as the owner rather than the user and the owner may not have permissions on the table?! Art S. Kagel