Subject Single sign on
Author martin.agren

I use firebird roles to give users differentiated rights in the database. When using 1.5.3 I assigned the appropriate role at logon by first querying a table where that particular users role name was defined.
Moving to 2.5 I want to take advantage of the trusted authentication scheme while still using the existing role model.

The prefered way for this would be to assign active directory users to three different AD groups matching my database roles.
At logon I'd like to pick up the group and assign the applicable role.

Any thoughts? Can I use a connection trigger?