authenticate oracle users

[marinac]

Hi,

I need to authenticate all my oracle users (~ 3000 ) in the web app ( jboss4/apache). How should I start doing that? Thanks for your help.

[jaikiran]

I need to authenticate all my oracle users (~ 3000 ) in the web app

Not quite sure about your requirement. Do you mean that you want your web app to be secured so to allow only role based access? If yes, then these might be some starting points:

http://www.onjava.com/pub/a/onjava/2001/08/06/webform.html

http://java.boot.by/wcd-guide/ch05s03.html

http://docs.jboss.org/jbossas/admindevel326/html/ch8.chapter.html

[marinac]

Thanks for your links, very interesting the one for WCD.
I have a web application and I have an oracle database with oracle users. The request is to authenticate the oracle users and this was my issue. How do I query the database for passwords? I found out that I cannot do that, please see below link.
(http://asktom.oracle.com/pls/ask/f?p=4950:61:15468414540126688::::P61_ID:258715248980)

So I will try for the moment to extract some users and passwords into a user defined table and I will try the form based authentication.

My question is now how do I match the j_username and the j_password from the login form with the values from the database?

Thanks.