Hi,
I have here Geoserver 2.0.1 and Oracle 10g (10.2.0.4.0) and it seems to be
enough in our environment to grant SELECT for the data. I have not tried with
2.0.2.
-Jukka Rahkonen-
________________________________
Primoz Kogovsek wrote:
Hello!
I have problem with grants in oracle database for publishing layer.
I have connected oracle database with geoserver. I added oracel data
store to geoserver stores and I can see resources contained in the store.
But the problem is when I try to publish a layer from this data store.
When I publish data with user that has dba rights it works fine.
But when I try to publish data with user we have specially for
publishing data I get error.
...
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: Error looking up primary key
at
org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:825)
at
org.geotools.jdbc.JDBCFeatureSource.<init>(JDBCFeatureSource.java:76)
at
org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:709)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:383)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:348)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:647)
at
org.geoserver.catalog.CatalogBuilder.buildFeatureType(CatalogBuilder.java:324)
at
org.geoserver.web.data.layer.NewLayerPage.buildLayerInfo(NewLayerPage.java:198)
... 70 more
Caused by: java.sql.SQLException: ORA-00942: table or view does not
exist
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
.......
Publishing user has SELECT grant over the data table and SELECT grant
over MDSYS SDO* tables.
I think I must grant some more tables for this user but I have no idea
which?
Geoserver 2.0.2
Oracle 11g Rac (JNDI)
Apache Tomcat Version 6.0.29
Windows Server 2008 32-bit
Thanks and regards
Primoz
--
Primož Kogovšek
Geografske informacijske rešitve
Primož Kogovšek s.p.
Koroška cesta 16
4000 Kranj
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
