martha123456_at_hotmail.co.uk wrote:
> 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
No. Create your own user/password table.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun May 14 2006 - 17:25:35 CDT
