heineferreira wrote:

> How do I see a list of logged in users (connections) in a database?

Read the MON$ATTACHMENTS system table.

> Is there a SQL command that can kill a user's connection?

Delete from MON$ATTACHMENTS (I'm not sure if this is supported yet in 2.5).

> Is it possible to get a list of locks on a database?
> Is it possible to delete a lock with a sql command, e.g. in case of deadlock?

Unline MSSQL Firebird uses record-level MVCC, so deadlocks happen very
rarely and are short-lived (they timeout after a minute or something
like that) so you would probably never need such feature with Firebird.


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================