i can also confirm that we can do this with users with only create session
and select on the target table privledges. in your datastore config have
you explicitly set the SCHEMA that the data is meant to be in, which is
perhaps different to the 'publishing (connecting) user' ?
can you connect using sqlplus as the publishing user and perform the same
select query that geoserver is trying to perform ? (the exact sql is in the
geoserver log if you turn verbose logging on)
-i
2010/9/29 Rahkonen Jukka <jukka.rahko...@mmmtike.fi>
> 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
>
>
------------------------------------------------------------------------------
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
