Subject Re: [Firebird-Java] Firebird with Jaybird
Author Gustavo Ruiz
Hi again, excuse me for the grammar.
I configure a datasource in tomcat whit username,
password and sqlRole parameters, and open connection
in a database, but throw exception: no permissions for
select in a table.
In a firebird Database i create a role READ, and
granted permissions for select in tables, after
role READ to user tomcat.
If i connect with isql connect test.fdb user tomcat
role READ, all works fine, but if i connect with jdbc
connection from datasource previously configured,
sqlexception "no permissions..." after execute a
query, because i suppose the connection no connect
with role READ.
What's wrong?????.
Thanks for all.

--- Roman Rokytskyy <rrokytskyy@...> escribi├│:
> > hello everybody, as I connect to firebird with
> jdbc or
> > datasource with a user who has a role, since to
> > connect itself with a role in firebird it is
> necessary
> > to specify it when one is connected.
> > ej:connect test.fdb user test password secret role
> > read
> See
> and
> Roman
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion
> Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> Yahoo! Groups Links

Ruiz Santicchio Gustavo Javier
CUCAIBA - Sector C├│mputos
Tel: (0221)427-6070 int 214
La Plata - Argentina

100mb gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo