Need help in connecting to JDBC, using a user role.

Hello,

I am using jsp as front end and oracle(8.1.X) backend in application. I am
using OracleDriver to coonect to the jdbc, by providing necessary parameters
as shown below.

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@"
                        + host_name + ":" + port + ":" + sid,
                        username, password);

What my requirement, users may have many roles, user can choose one of the
roles for the login, how can i specify that role in the connection string.
Snippet is useful and any suggestions also helpful.

Thanks in advance....
----------
Madhu V

___________________________________________________________________________
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html