Get connected clients IP in Firebird
<p>I have a Firebird database hosted on a server. Firebird can display a list of connected users, with username, role etc, with the <code>MON$ATTACHMENTS</code> table. But, I can't find out how to get IP address of one specific client.</p>

<p>Exemple : if the user "USER", from <code>192.168.1.77</code>, is connected on <code>192.168.1.2</code> (server), how can I get this <code>192.168.1.77</code> address with Firebird query ?</p>

<p>Edit : <code>MON$REMOTE_ADDRESS</code> shows the DHCP server address, not the local client one.</p>