So far i am only able to publish the tables with user that is owner of the
schema. With different users it is no go. Any ideas how to fix this?
regards
Primoz
2010/9/29 Ivan Price <ivan.pr...@acted.org>
> 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
>>
>>
>
--
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
