Subject Re: [Firebird-Architect] Create User Proposal
Author Dmitry Yemanov
"Samofatov, Nickolay" <nickolay@...> wrote:
>
> Also I can trivially add a couple internal_info nodes to provide access
> to this information from DSQL.

Please, don't do that. Do you want every internal info to be represented
with a separate language pseudo-variable? I don't think so. The key idea
was: (a) provide all access internals via monitoring tables and (b) use
CURRENT_CONNECTION and CURRENT_TRANSACTION as primary keys to access
attachment and transaction monitoring tables. You don't need
CURRENT_IP_ADDR, you just need SELECT USER_IP_ADDR FROM SYS$ATTACHMENTS
WHERE SYS$ATTACHMENT_ID = CURRENT_CONNECTION. That's all.


Dmitry