Pass Native XDB Web Service on to another DBSCHEMA
11.2.0.3
I have a native XDB Web Service up and running under SCHEMA1. This SCHEMA1 of course has a username/password.
The current URL for the WSDL is: http://localhost:3334/orawsv/SCHEMA1/PACKAGE1/PROC1?wsdl
Works great.
I have a third party that wants to access the web service but I can't give out the SCHEMA1 password. The third party has their own login to the database SCHEMA2 with their own username/pwd.
I granted SCHEMA2 xdb_webservices & xdb_webservices_over_http.
I granted SCHEMA2 execute on package1 to SCHEMA2.
I setup a synonym from SCHEMA2 to SCHEMA1.package1 (same name).
I have a native XDB Web Service up and running under SCHEMA1. This SCHEMA1 of course has a username/password.
The current URL for the WSDL is: http://localhost:3334/orawsv/SCHEMA1/PACKAGE1/PROC1?wsdl
Works great.
I have a third party that wants to access the web service but I can't give out the SCHEMA1 password. The third party has their own login to the database SCHEMA2 with their own username/pwd.
I granted SCHEMA2 xdb_webservices & xdb_webservices_over_http.
I granted SCHEMA2 execute on package1 to SCHEMA2.
I setup a synonym from SCHEMA2 to SCHEMA1.package1 (same name).
0