Subject Re: [firebird-support] How can I prevent that my database can be opened with another security.fdb.
Author Thomas Steinmaurer

> Dear all,
> Though I don't have the same question as Roland, information below by Virna
> Constantin (costel_61@...) is very useful.Thanks every one.
> Regards,Tjioe
> Suggestion
> event studies "on connect"
> 1. an application with minimum rights connects to the database
> 1 '. in table "mon$attachmnts" field "MON$REMOTE_PROCESS" will record the
> application name
> 2.  in the trigger event "on connect" if the user connects SysAdmin, verifies
> the application name in "MON$REMOTE_PROCESS"

Just FYI: In practice it is possible to suppress database triggers (DPB: isc_dpb_no_db_triggers) when connecting as the database owner or as SYSDBA. E.g. isql has a special command-line option "-nodbtriggers" to bypass database triggers at connect time to e.g. modify/drop the trigger afterwards.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.