|Subject||Re: [Firebird-Architect] Database triggers|
> >>> This would be a very starting point for virtual tables. Rather thanIt will perfectly work with any external storage - external tables, for example.
> >>> 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.
And ON ROLLBACK triggers help to distinguish unsuccessful attempts to do