--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@...> wrote:

>
> > 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.
>
> Either use CURRENT_CONNECTION (it will return integer),
> or in FB2 new system functions RDB$SET_CONTEXT, RDB$GET_CONTEXT.
>
> Ivan
>

i tried using the rdb$set_context and the rdb$get_context but it
return error function unknown. im using firebird version 2.0 beta 2.