Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle database validating password

Oracle database validating password

From: <martha123456_at_hotmail.co.uk>
Date: 14 May 2006 09:35:23 -0700
Message-ID: <1147624523.244430.47820@i40g2000cwc.googlegroups.com>


Hi, this is my first post to this group.

I have a webservice that receives a username and password for an Oracle database over https (eg. scott/tiger). I communicate with the database using a different username and password from my webservice code (eg. webservice001/ijHHGuy762) and there is only one connection. I want to validate the scott/tiger pair passed in the webservice with Oracle using the connection I made with webservice001/ijHHGuy762 and see whether it is valid before returning table information. I want to do it like this as I do not want to have a separate connection for every user and connecting as a new user each time is very slow.

Without connecting to Oracle as scott/tiger, is there a package/procedure in Oracle I can call connected as webservice001/ijHHGuy762 to verify scott/tiger is valid.

I am running Windows 2003 Web Edition and Oracle XE.

Thank you
Martha Smythe-Harrop Received on Sun May 14 2006 - 11:35:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US