> SYSDBA users can see other connected users using monitoring tables but is it > possible to implement such feature for non-SYSDBA users? Are there > event/triggers that act uppon connecting and disconnecting and which can > insert > usual database records. Triggers no MON$ tables are not suitable because MON$ > tables are populated only during query time.
The following users get the full picture when querying monitoring tables: * Database owner * SYSDBA * Users as a member of the special per database RDB$ADMIN role. Role needs to be specified at connect time. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.