Is there a way to incorporate ROLEs with the jdbc url?


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!

Any help would be greatly appreicated.

Thank you very much and have a great day.