Subject Re: User Sessions
Author kevtey
--- In, "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
> > (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.