we've been thinking about row level security on and off, and there are some threads on Geonet about this, but the general consensus seems to be that this can't really be done properly: Oracle has Label Security (Enterprise Edition only!), SQL Server suggests using views, but integrating these things into a geodatabase with versioning, complex datatypes (not to mention geometric networks) etc. doesn't seem to work very well.
Recently, Esri has come up with some new technology: ArcGIS Pro is a lot better than ArcMap in transparently editing feature services (no need for local FileGDB caches), and ArcGIS Server has introduced Server Object Interceptors, which can modify service requests and results.
Has anyone thought about or even tried implementing fine-grained access control with these techniques? Like label security (access based on a feature attribute) or spatial access control (access based on intersection with a polygon)? Obviously, there would be limitations since feature service editing doesn't (yet) handle things like geometric networks, but what can be done?