Hi, Our process modifies the Postgres/PostGIS tables with new columns that we use for security filtering. In our case, it is acceptable for the filter values to be visible to users.
One method I am aware of is to modify the request params adding in the PropertyName=Comma,Delimited,FieldNames. You would probably have to check for a propertyname list and remove your filter columns if it exists. Or, create a completely new param listing the acceptable columns and adding it to the request. You can also create a post filter with SPRING and add it to the outbound filter chain removing the column when it is JSON or GML based output. Possibly the CSV output. The shapefile result type would be more problematic to remove the filtering columns from the feature type, but is still doable. Maybe one of the core developers know of a way to restrict the columns in the result set in a more elegant manner. One example I found from the client side restricting the values. https://wiki.state.ma.us/confluence/display/massgis/GeoServer+-+WFS+-+Filter+-+Get+Subset+of+Attribute+Values+for+a+Feature+-+Complex+Filter+2 Chris Snider Senior Software Engineer Intelligent Software Solutions, Inc. -----Original Message----- From: Feniks [mailto:svab.ma...@gmail.com] Sent: Thursday, June 05, 2014 6:10 AM To: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] WFS,WMS per feature security Chris, I managed to implement DispatcherCallback which checks for the CQL and changes it ... Now one question, by which feature property did you filter, did you have a special property for that? I see a problem if there is a column in the DB which is only for this filtering, meaning it's going to be visible in the WFS request but we don't want for that feature property to be visible in the WFS response, so is it possible to somehow hide it? Thanks Matic -- View this message in context: http://osgeo-org.1560.x6.nabble.com/WFS-WMS-per-feature-security-tp5143498p5144206.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
