On 31 Jan 2006 at 0:38, William L. Thomson Jr. wrote:

>I have a stored procedure that has an insert to a table I want to be
>excluded for a particular user. Partly because they do not have
>permissions to access that table at all. Also that the insert should
>take place for every user but the one.
>
>Comments, thoughts, advice is all greatly appreciated.

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.

--
SY, Dimitry Sibiryakov.