Is there a definitive list anywhere? (Would be jolly useful addition to
GeoServer Oracle Plugin documentation)
From: Michael Shishcu [mailto:mickl...@gmail.com]
Sent: 01 March 2012 14:33
To: Mark Hammond
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle permissions
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 <mark.hamm...@bto.org> 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
Geoserver-users@lists.sourceforge.net
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
