Ok, thanks Karol for your interest, and sorry if I'm not explain clearly ;)
2018-02-17 20:43 GMT+01:00 'livius' liviusliv...@poczta.onet.pl [firebird-support] <firebird-support@yahoogroups.com>: > > > Yes, i have assumed this > Now it is much clearer. You have 1 DB user and many application user. > Then yes, context var is your friend > > regards, > Karol Bieniaszewski > > From: marco andreolli dra...@gmail.com [firebird-support] > Sent: Saturday, February 17, 2018 9:03 AM > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Re: Set custom value on connection system > info > > Hi, sorry Karol if I dont't reply until now. > > I think you you assume I have a Firebird user for any user application, > but I have a only one firebird user for all my application. So > MON$ATTACHEMNTS..MON$USER is the same for all connections! > > Il 10 feb 2018 16:46, "'livius' liviusliv...@poczta.onet.pl > [firebird-support]" <firebird-support@yahoogroups.com> ha scritto: > > Hi, > > you store in your persistent table login (user_name) it is presistent > information. > You join your persistent table which should contain login name and you > join your persistent table with mon$attachment an you know who is currently > logged in. > > once again sample > > CREATE TABLE MY_USERS > (USER_ID INTEGER NOT NULL PRIMARY KEY, > NAME VARCHAR(32) NOT NULL, > AGE INTEGER, > ..... > LOGIN_NAME VARCHAR(32) NOT NULL > ); > > sample record > USER_ID=1 > NAME=’Karlos’ > AGE=52 > .... > > LOGIN_NAME=’SYSDBA’ > > and you run sql > > SELECT * FROM MY_TABLE MT INNER JOIN MON$ATTACHEMNTS A ON > A.MON$USER=MT.LOGIN_NAME > > regards, > Karol Bieniaszewski > > From: marco andreolli dra...@gmail.com [firebird-support] > Sent: Saturday, February 10, 2018 9:15 AM > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Re: Set custom value on connection system > info > > Hi, > > I have a table of users, but I wouldn't store in persistent table a > volatile information (if it was possible). > > The link between a connection id and user id isn't a persistent > information (like connections,transaction ecc...) > > 2018-02-08 6:19 GMT+01:00 liviuslivius liviusliv...@poczta.onet.pl > [firebird-support] <firebird-support@yahoogroups.com>: > > Hi, > > what do you mean by maintain here? Do you have custom user information > table or not? If not then what do you need to store in this context var? > > I supposed that you have custom user information table and you need to > match your user record with server user to know who is logged into the > server. > > Regards, > Karol Bieniaszewski > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > >
