I have not used it, but I believe that the GeoFence community module may be able to do what you want:
http://docs.geoserver.org/latest/en/user/community/geofence-server/index.html
According to this documentation, you can specify a CQL filter to restrict access to features:
https://github.com/geoserver/geofence/wiki/Main-concepts
If the filter has access to the user name, and the owner name is present as a property in the feature, then you could test them for equality.

You should start a new thread in this list to attract the attention of GeoFence experts.

Kind regards,
Ben.

On 19/03/18 23:32, Karthikgb wrote:
yes I have to go through the spacial indexing. I am grateful for the replay.

- Our dataset is a collection of some objects [car, bus, cycle] where each
object represented in each wms layer in client side using Openlayer.
- All the metadata of all the objects = car, bus, cycle is stored in SQL DB
with its personal data and its
   latitude and longitude of that point in its row.
- I have created 3 query for 3 layer (car , bus , cycle) to create 3 wms
layers.
- But now I want based on the owner permission only some object must be
shown at the client side
   Ex: owner 1 have permission for 1000 bus out of 50000 busses.
- How can I make a proper use of the geoserver and Openlayer and Sql db. To
reach this output.
- Do we have any approach to pass dynamic sql query and create wms layer for
that query result
   dynamically using geoserver or any other opensource tool I should use.
- I have to handle 1000000 points and min 1000 user accessing them with
respected permission.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


--
Ben Caradoc-Davies <b...@transient.nz>
Director
Transient Software Limited <https://transient.nz/>
New Zealand

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to