--- In firebird-support@yahoogroups.com, "vandy899" <vandy899@y...> wrote:

>
> --- In firebird-support@yahoogroups.com, "Ivan Prenosil"
> <Ivan.Prenosil@s...> wrote:
> > > That's not the way I understood it... I created these objects as
> > > SYSDBA, GRANT EXECUTE ON PROCEDURE $PROC to $USER, but when I

EXECUTE

> > > PROCEDURE $PROC, it states that I don't have sufficient privs to
> > > INSERT INTO - despite the fact that SYSDBA obviously has
> sufficient privs.
> >
> > You have to grant insert right to the procedure.
> >
> > Ivan
>
>
> So, that's something like (where $table is the table, $proc is the
> procedure) "GRANT INSERT ON $table TO PROCEDURE $proc". What are the
> semantics of that? Are procedures that it calls granted those same
> privs in context of that caller calling them? (Sort of like an euid
> == 0 process calling another process, and that then having euid == 0
> as a consequence).
>
> Cheers,
>
> Michael

I just tried that, and it worked. Many thanks to Ivan and Ann for
helping me out.

Cheers,

Michael