Subject Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username
Author Thomas Steinmaurer
> On Thu, 14 Apr 2016 12:28:41 +0200 (CEST), 'Thomas Steinmaurer'
> ts@... [firebird-support] <firebird-support@yahoogroups.com>
> wrote:
>>
>>
>> Yep. If one want to have some sort of client login/user available on
>> the server-side, which might be totally different to the Firebird
>> user used upon connect time, a common approach is to put that login
>> name into a context variable via RDB$SET_CONTEXT(...) and query that
>> in context of the connection with RDB$GET_CONTEXT(...). Needless to
>
> Unless I'm misunderstanding it, it is not possible to read
> context variable from another connection?

No. There are two "namespaces" USER_SESSION and USER_TRANSACTION which also define the visibility of context variable values.

Check out: http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-set_context.html


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.


>
> --
> Virgo Pärna
> virgo.parna@...
>
>
>
> ------------------------------------
> Posted by: Virgo =?UTF-8?Q?P=C3=A4rna?= <virgo.parna@...>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu. Try FAQ and other links from the left-side menu there.
>
> Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ------------------------------------
>
> Yahoo Groups Links
>
>
>