Subject Re: [Firebird-Architect] Database triggers
Author Vlad Horsun
> >>> This would be a very starting point for virtual tables. Rather than
> >>>
> >>> What account do the trigger run under?
> >>>
> >> Under account of user who initiated action. All proposed triggers
> >> fired at moment where valid user account is established
> >>
> >
> > That really won't work for before connect or after disconnect triggers.
> >
> >
> It particularly doesn't work when you're trying to keep an audit trail
> that readonly (or no access) to most users.
> There is also a problem with logging a violation when the trigger throws
> an exception: Exception -> rollback -> log record disappears.

It will perfectly work with any external storage - external tables, for example.
And ON ROLLBACK triggers help to distinguish unsuccessful attempts to do