> 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.


  • [firebird-su... jonatan.laurit...@yahoo.dk [firebird-support]
    • Re: [fi... Stefan Heymann li...@stefanheymann.de [firebird-support]
    • Re: [fi... 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
      • Re:... Dalton Calford dcalf...@distributel.ca [firebird-support]
    • Re: [fi... Ivan PÅ™enosil ivan.preno...@seznam.cz [firebird-support]
      • Re:... rem...@yahoo.com [firebird-support]

Reply via email to