Hi Mark,
In order to access the databasethe user you create has to have other system
grants, such as CONNECT, RESSOURCE etc.
Also, probably, the should have to metadata of the layers (*
USER_SDO_GEOM_METADATA*).
Please check the Oracle Documentation for that
regards, michael
On Thu, Mar 1, 2012 at 4:11 PM, Mark Hammond <[email protected]> wrote:
> Hi,****
>
> ** **
>
> We are connecting GeoServer to an Oracle database in order to publish
> tables.****
>
> ** **
>
> In keeping with good practices, we wanted to create an Oracle user with
> minimal permissions required to do the job for GeoServer to use. Creating a
> user with SELECT permissions on the tables we want to publish means that we
> can neither publish nor preview a layer from the database. Using my super
> user credentials (read/write to everything) it works.****
>
> ** **
>
> Could you tell me what the minimum requirements for publishing and using
> an Oracle layer are so that I can adequately set up permissions?****
>
> ** **
>
> Mark Hammond
> Web Software Developer
> British Trust for Ornithology, The Nunnery, Thetford, Norfolk, IP24 2PU, UK
> ****
>
> *' **Scribo ergo sum dolor* *'*
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Virtualization & Cloud Management Using Capacity Planning
> Cloud computing makes use of virtualization - but cloud computing
> also focuses on allowing computing to be delivered as a service.
> http://www.accelacomm.com/jaw/sfnl/114/51521223/
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
