Roberto,

R> Thank you, Adam, your SP solution to get a "user inoffensive string"
R> from a connection seems to be viable with Firebird 1.5. I'll try it.
R> As you and Nando said, it would be easier with Firebird 2.0, using the
R> two system functions RDB$SET_CONTEXT and RDB$GET_CONTEXT to set and get
R> values as I need.
R> Is FB2 already available? Is it safe for a producer environment?

I think it is, and I have only seen beta 2 so far. RC1 (out these
days) should be even stabler.

But you seem to have missed or not considered enough that what you are
after is best done through SQL ROLES, which are the SQL-standard
equivalent of application names, and more granular.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================