Without permission, a user (husband) can peek at the relationships in the world of another user (wife). Good job, ESRI. You expose users' privacy. For an enterprise geodatabase (ArcGIS 10.5.1) atlas in an instance of SQL Server 2014, I created 9 users/schemas. The schema gio associated with user gio owns its two feature classes (FireDistricts, Tax_Parcel_Polygon). No any permission for user gio to do anything on other data in other schema. However, the user gio can still see the relationship classes in the schema laurens associated with the user laurens.
... View more