Suppose I have procedure P1 that calls procedure P2,
procedure P2 calls itself recursively.
Public has granted Execute rights on procedure P1,
procedure P1 has granted Execute rights on procedure P2.

The question is - do I need to
GRANT Exectue ON PROCEDURE P2 TO PROCEDURE P2 ?

I can imagine these answers:

- NO, because procedure should always be able to call itself
- NO, because P2 is called "in the context" of P1 that has required right
- YES, (this is correct answer for InterBase)

Any opinions ? Does SQL standard have anything to say about it ?

Ivan
prenosil@...