On 11 Sep 2006 at 9:03, PenWin wrote:

>query through EXECUTE STATEMENT query INTO :field1, :field2... While
>the procedure has rights to the relevant tables granted (through
>statements similar to those above), it still fails with an error
>message "No permission for read/select access to table PRICES". Any
>idea why?

Because statement in EXECUTE STATEMENT is executed with user's
rights, not with procedure's ones. Security, as you, propapbly,
understand.

--
SY, Dimitry Sibiryakov.