How to organize monitoring of calls to the Firebird database?

Question

Database

What are the ways to track database access on Firebird. Connection through the same IB-expert. Where is this information stored and how can it be retrieved.

Answer 1

And what is the version? If this is a classic server under linux, xinetd controls all connections there, everything is logged for it.
By the way, the expert has the option of logging all edits in tables. All this is stored in the same database.

Answer 2

For firebird versions >= 2.5 you can use "Database triggers" ON CONNECT and ON DISCONNECT

Answer 3

There is such thing as FireBirdScanner ( www.ibsurgeon.com/en/fbscanner-firebird-scanner/) - monitors all database connections. It also has the function of logging all actions from the database to a separate database. 1n big only nuance - paid.