Subject | Re: [firebird-support] Re: Connecting to Firebird database from two or more pc with same username |
---|---|
Author | Virna Constantin |
Post date | 2016-04-19T04:15:30Z |
I hope I did do not a fixation by "on connect" :D
SET TERM ^ ;ALTER TRIGGER USER_ON ACTIVEON CONNECT POSITION 0ASdeclare variable m_gaz varchar(25);BEGINselect mon$remote_address from MON$ATTACHMENTSwhere mon$attachment_id=current_connectioninto :m_gaz;rdb$set_context('USER_SESSION','Gazda',:m_gaz);rdb$set_context('USER_SESSION','Acces',0);rdb$set_context('USER_SESSION','ContEdt',0);rdb$set_context('USER_SESSION','Import',0);insert into USER_MSG (id_con,usser,roll,data_con,comm)values (current_connection,current_user,current_role,current_timestamp,'');END^SET TERM ; ^sorry for my englesh :(