> -----Original Message-----
> Just to add a little weight to this question, we also have
> the same issue.
>
> It would be great if there was a way to see which user was
> locking a record so that the administrator could give them a
> little nudge to rollback or commit their transaction. It
> would be even nicer if the transaction could be
> committed/rolledback by SYSDBA.

Although seeing who has what locked would be useful, isn't it a question of
design, to me, and I may very well be alone in this, the life of a
transaction should be as short as humanly possible to get the job done.
There shouldn't be a need to keep a transaction open for hours/days/weeks
etc.

Rgds

Si Carter
http://www.fbtalk.net/ - Web Based Firebird Forum
http://sourceforge.net/projects/fbutils - FBUtils
http://sourceforge.net/projects/dnfbb - Web based, Firebird Powered Forum