3 Replies Latest reply on Mar 11, 2013 9:28 PM by Bkazar-Oracle

    WFS administrator privileges

      hi everyone,

      I have some problems with Oracle Spatial WFS, working with Oracle Database EE 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,