Subject | Re: [Firebird-Architect] Database triggers |
---|---|
Author | Adriano dos Santos Fernandes |
Post date | 2006-09-20T00:08:25Z |
Ann W. Harrison wrote:
If db triggers are allowed to be created by any user, they can cause the
mentioned problems (exceptions in CONNECT, etc).
As the trigger is of the DATABASE, only who can alter the database
(currently sysdba/owner) should be allowed to create it.
Adriano
> how do you keep some random person from creating a triggerYou made a interesting point.
> to harvest user names?
>
If db triggers are allowed to be created by any user, they can cause the
mentioned problems (exceptions in CONNECT, etc).
As the trigger is of the DATABASE, only who can alter the database
(currently sysdba/owner) should be allowed to create it.
Adriano