I have some problems with Oracle Spatial WFS, working with Oracle Database EE 184.108.40.206.0 running on Ibm AIX 5.3.
My question is: what kind of privileges have to be granted to a user "*wfs administrator*" in order to perform methods of package SDO_WFS_PROCESS like InsertCapabilitiesInfo or PublishFeatureType ?
In the wfsrelmd.sql script file (coming with the wfsclient.jar example) the "*wfs_admin_usr*" user has the DBA role granted.
This is not possible in my organization, and if I try to execute the methods of SDO_WFS_PROCESS package (without the DBA role granted) this error occurs:
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "MDSYS.SDO_WFS_PROCESS", line 150
ORA-06512: at "MDSYS.SDO_WFS_PROCESS", line 20
ORA-06512: at line 4
Can you please give me any suggestions?
Many thanks in advance,
be careful that SDO_WFS_PROCESS is a "package" object type (compiled with AUTHID CURRENT_USER clause) of MDSYS Oracle Spatial owner.
I am not really sure that the "select" privilege is allowed in this case.