Accessing a Public table through SOAP fails - Support and Troubleshooting

Accessing a Public table through SOAP fails Description  Error when retrieving Public table data using SOAP

Problem Unable to retrieve a record from a table using SOAP web service.

Symptoms Public table is queried (the sys_public table has an entry for this table and the value is true) and the following error is returned to the SOAP client application:

c om.glide.processors.soap.SOAPProcessingException: insufficient rights to read com.glide.processors.soap.SOAPProcessingException: insufficient rights to read at com.glide.processors.soap.command.Get.process(Get.java:54) at com.glide.processors.soap.SOAPProcessorThread.doCommand(SOAPProcessorThread.java:305) at com.glide.processors.soap.SOAPProcessorThread.doCommand(SOAPProcessorThread.java:294) at com.glide.processors.soap.SOAPProcessorThread.processStandardWebService(SOAPProcessorThread.java:226) at com.glide.processors.soap.SOAPProcessorThread.processBody(SOAPProcessorThread.java:204) at com.glide.processors.soap.SOAPProcessorThread.processRequest(SOAPProcessorThread.java:171) at com.glide.processors.soap.SOAPProcessorThread.run0(SOAPProcessorThread.java:129) at com.glide.util.ParentedThread.run(ParentedThread.java:51)

Cause When the SOAP processor receives a request to access a public page, it is processed as the "guest" user. The guest user is unable to process the SOAP request, even though it is a public page.

Resolution To workaround the issue, use a database view that is not public to: enable the correct user to authenticate correctly evaluate against all applicable ACLs Workaround steps:

Create a database view against the table in question that is public (do not make the view public). Add read/create/write ACLs to the database view. Consume the WSDL of the database view. Run the SOAP requests against the view. Warning : Do not add the database view to the sys_public page. This view must not be public, or the same error occurs.