Subject | Re: [ib-support] Privilege check? |
---|---|
Author | Ded |
Post date | 2001-04-12T09:27:58Z |
Helen Borrie wrote:
Best regards.
> At 12:04 PM 12-04-01 +0400, you wrote:Hi, Helen. I mean: Are set of actions named "Prepare" the same about privileges in SQL realizations that interpret code of SP and triggers or not. Thank you.
>
> > 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.
>
Best regards.