Is there some function/procedure/package that validates a username and password in
Oracle (from a user that exists in the db)?
Background: We want to create a web application that will use a pool of connections. All users already exists in the database, because of a legacy 6i application. So we think that the best approach is to validate the user and password of the database, but we don't want to hardcode the url and open a new connection just to validate this.
I know that another way is to store a password in a user's table, but if the Oracle provide this option will be much easier.
I found out a unofficial script that verify the Oracle's
Perhaps you should look into Proxy Users. They are specifically designed to have end-users authenticate against the database in a 3-tier architecture.
We use LDAP for app level authentication.
I don't think this will work.
You alread stated that Proxy Users don't work for your purpose
Tom Kyte says it doesn't work. And normally Tom Kyte is right about anything Oracle http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:73704414259631 although that thread is pretty old ...