--- In firebird-support@yahoogroups.com, "Dimitry Sibiryakov" <SD@t...>

> No luck to you. Firebird engine does not analyze execution path and
> thus checks permissions for each statement inside SP no matter
> whether it will be executed or not.

Ah so it's just a matter of granting permissions and then the
statement will work as intended and just not get fired. Not to worried
about the granting aspect from a security perpective. More the
functionality, just wanted to avoid the grant if possible. I will
grant and proceed. Thank you.