Subject | Re: [Firebird-Architect] Create User Proposal |
---|---|
Author | Dmitry Yemanov |
Post date | 2004-09-24T12:32:56Z |
"Samofatov, Nickolay" <nickolay@...> wrote:
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
>Please, don't do that. Do you want every internal info to be represented
> Also I can trivially add a couple internal_info nodes to provide access
> to this information from DSQL.
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