Hi, > Dear all, > Though I don't have the same question as Roland, information below by Virna > Constantin ([email protected]) 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 http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.
