I know that you solved your problem.
But why you store ID from your custom table into context var 
not oposite USER_NAME in your custom user table? Then you do not need var at 
all.

regards,
Karol Bieniaszewski

From: marco andreolli dra...@gmail.com [firebird-support] 
Sent: Monday, February 5, 2018 9:11 AM
To: firebird-support@yahoogroups.com 
Subject: Re: [firebird-support] Re: Set custom value on connection system info

  

Wow, thanks!
This is what I really wanted 


I never known the existence of that system table. 

Actually I use RDB$SET_CONTEXT for store user name and id; with this table I 
could know the user really logged in 


Thanks Dmitry 



2018-02-04 13:46 GMT+01:00 Dmitry Yemanov dim...@users.sourceforge.net 
[firebird-support] <firebird-support@yahoogroups.com>:

    
  03.02.2018 23:14, marco andreolli wrote:
  >
  > but RDB$SET_CONTEXT() it's not right for me, because it store 
  > information in actual connection (or transaction) and they can not be 
  > read out of this (with a monitor program for example).

  It can be, via MON$CONTEXT_VARIABLES.

  Dmitry





  • [firebird-s... marco andreolli dra...@gmail.com [firebird-support]
    • [fireb... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
      • Re... marco andreolli dra...@gmail.com [firebird-support]
        • ... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
        • ... Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
          • ... marco andreolli dra...@gmail.com [firebird-support]
            • ... 'livius' liviusliv...@poczta.onet.pl [firebird-support]
              • ... marco andreolli dra...@gmail.com [firebird-support]
                • ... liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
                • ... marco andreolli dra...@gmail.com [firebird-support]

Reply via email to