> I am trying to connect to a firebird database using a 3rd party
> application. When I connect (using the jdbc url), I am not able to
> view all the data that the users have access. I have created a role to
> grant table/view privledges. The priveledges granted for that role
> does not seem to work. What can I do about this? Can I put the role
> in the jdbc url? I could go and grant privledges for each table, but
> that will be 200 tables!

jdbc:firebirdsql:localhost/3050:c:/database/my.fdb?roleName=MY_ROLE

this property is also available in connection pooling classes.

Roman