Using the query

select a.MON$USER, a.MON$ROLE, a.MON$REMOTE_ADDRESS, a.MON$REMOTE_PROCESS, t.MON$TIMESTAMP, t.MON$TRANSACTION_ID
from mon$transactions t join mon$attachments a on (t.mon$attachment_id = a.mon$attachment_id)
where mon$transaction_id = 478349

i can get the user who has applied a lock.

Is it possible to enable all users of a role to be able to access this information? I'm not very sucessful when trying out grants on the system tables. Perhaps it's a dangerous and preposterous idea security-wise?

Thanks you so much!

Regards,

/Dany