Ahmet Elgin wrote:

>Hi All,
>In my application i have a user table and manage user rights on
>runtime. All users connect to database with one database user. Now i
>want to log records on same tables, but i can't get user name on a
>trigger. Is there any way to get session spesified value for a session.
>(for ex. session id) If i get a unique value then when a user connects i
>will write it on a table with user name on my user table.
>
>thanks for your help
>Ahmet Elgin
>
>

Ahmet,

Look for CURRENT_CONNECTION, CURRENT_TRANSACTION on the FB release notes.

Note that those values reset !!!

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br