Hello, I am wondering if it possible to share only a subset of features from an enterprise database as an editable feature service? This would be similar to creating a view layer with hosted data with a feature query enabled. The data would be referenced to the DB, not copied to the server.
I already know about filtering the data or applying a definition query prior to or after sharing, but these two options still allow the end user to turn off the query and access all features. I would want the limitation enforced on the users and not able to be turned off by end users. A database view will not fit the need either, as it does not support editing.
I am also aware of the option to limit editing to features owned by the user, but this does not quite fit the need either. The users would still be able to view other features and unable to edit features they do not own. Is there any options I may be missing?
Requirement:
1. Editable Feature service
2. Source = Registered enterprise database feature class, referenced data
3. Only a subset of features is accessible and editable in the feature service.
4. The subset setting cannot be modified by non-owners of the feature service. End users would not be able to gain access to features not part of the queried subset.