How to check database user/password in a PL/SQL webservice
165611Feb 24 2010 — edited Feb 24 2010I am generating a PL/SQL webservice via JDeveloper.
On deployment, the web service is assigned to a datasource (the schema user in which the PL/SQL stored package procedure is).
Now everyone knowing the URL is able to call the webservice.
But i want to achieve the following 2 things:
1) the caller must provide a database user + password to be able to call the webservice
2) the stored procedure must be able to know this userid for implementing restrictions (e.g. not all users may access data of all projects)
How can i achieve this in a JDeveloper generated PL/SQL webservice?
I am currently using JDeveloper 9.0.4 and OAS 10g 9.0.4.
Thank you in advance for your help!
Best regards,
Udo