Subject | Re: [firebird-support] User Sessions |
---|---|
Author | Ivan Prenosil |
Post date | 2006-01-03T11:31:45Z |
> In my application i have a user table and manage user rights onEither use CURRENT_CONNECTION (it will return integer),
> 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.
or in FB2 new system functions RDB$SET_CONTEXT, RDB$GET_CONTEXT.
Ivan