Re: [Geoserver-users] Geoserver wms layer after adding 80000 rows in SQL table getting hanged

[Ben Caradoc-D. <be...@tr...>]

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
> 
> 
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
> 

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