At 12:04 PM 12-04-01 +0400, you wrote:

> Just curiosity: is it linked with fact that IB stores SP as compiled or it
>is more deep reason and SQL realizations that interpret SP during execution
>have the same behavior?

If you question means "Are privileges as known at compile time embedded in concrete by the compiler?" the answer is NO. The trigger has rights to operate on the table to which it belongs; except for that, it has to check both its own and the user's privileges at Prepare time.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________