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
granted
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
>

http://jaybirdwiki.firebirdsql.org/config/ObtainingConnectionViaDriverManager

> and
>

http://jaybirdwiki.firebirdsql.org/config/ListOfDPBProperties

>
> Roman
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion
> Toolbar.
> Now with Pop-Up Blocker. Get it for free!
>

http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM

>

--------------------------------------------------------------------~->

>
>
>
> Yahoo! Groups Links
>
>
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>

=====
_______________________________________
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
http://correo.yahoo.com.ar