Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle database validating password
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