Hi,

> Just another quick question. Are roles supported in Jaybird ?

Not tested. You can try to specify role in the DPB (either
FBConnectionRequestInfo if using FBWrappingDataSource or as connection
param, or in JDBC URL). Parameter name is "isc_dpb_sql_role_name" (or
"sql_role_name").

For example, you use following URL:

jdbc:....my.gdb?sql_role_name=USER

> I have defined a user which I can connect with OK when using the JDBC
> driver in interclient.jar.
>
> However when I try with the Jaybird driver it says that there is no
> permission to the table. This problem does not occur when using
> SYSDBA.

If the code above does not solve you problem, I would be grateful if
you can send me a test case with test database.

Best regards,
Roman Rokytskyy