This discussion is archived
3 Replies Latest reply: Mar 11, 2013 2:28 PM by bkazar RSS

WFS administrator privileges

137318 Newbie
Currently Being Moderated
hi everyone,

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

CarlT

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points