idea Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas in Data Management Ideas

Bug: Relationship Classes can be seen without permissions in ArcSDE/SQL Server

JerryGarcia — Tue, 30 Aug 2022 00:39:41 GMT

Relationship classes (and feature datasets) can be viewed by users who do not have permissions to the related data. This presents a security issue since users should not know any relathionships exist unless they are granted permissions to them.

See description of issue here:
http://forums.arcgis.com/threads/20223-See-Datasets-and-Relationships-without-granting-permissions

Re: Bug: Relationship Classes can be seen without permissions in ArcSDE/SQL Server

StephanieSnider — Wed, 09 Mar 2011 18:34:28 GMT

I completely agree. This is a 'feature' that has bugged me for a while. While the user cannot edit the relationship class, they can still see it. I think this is confusing for users and also a security issue.

Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

ChadMarch1 — Fri, 26 Aug 2022 00:13:12 GMT

Relationship classes, Feature Datasets, and topological datasets are viewable across all schemas of a db and is quite annoying.

I've done research and have found posts complaining about this since as early as 2009:
http://forums.esri.com/Thread.asp?c=158&f=2284&t=279568

and techinical articles posted recently explaining it:
http://support.esri.com/en/knowledgebase/techarticles/detail/22721

But y'all should really do something about this. If tables are contained to their schemas, related elements like RC's, FD's, and topology should all be as well.

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

ChadMarch1 — Mon, 07 Apr 2014 23:00:01 GMT

Correction, as early as 2005:
http://forums.esri.com/Thread.asp?c=93&f=1727&t=153382

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

Anonymous User — Tue, 27 Jan 2015 15:28:42 GMT

I agree, it a nuisance for other users when browsing for their data. Not to mention it could be a security risk for certain agencies to even know about it, otherwise, secure data will not be trusted in ESRI enabaled databases.

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

Anonymous User — Tue, 27 Jan 2015 15:30:54 GMT

Looks like they fixed it in ArcGIS 10.2.2 and 10.3! Good...

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

AnnetteFarrell1 — Tue, 24 Mar 2015 13:07:25 GMT

This does not appear to be fixed out of the box in ArcCatalog 10.2.2 connecting to SDE 10.2.2.
However there an option in ArcCatalog to filter out objects not owned by the connection user.

In ArcCatalog > Customise > ArcCatalog Options > General
Check the option 'List only objects owned by the connecting user with enterprise databases'

You need to disconnect and reconnect to the database for the change to be applied.

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

GangWang — Thu, 04 Jun 2020 20:12:39 GMT

the issue still exists in 10.7.1 to me. does anybody know where to find the option (List only objects owned by the connecting user with enterprise databases) in ArcGIS Pro?

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

RoyceSimpson — Wed, 18 Nov 2020 22:38:19 GMT

Still a super annoying issue as of 10.8.1. Does anyone know if there's traction on this?

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

DeanMoiler — Wed, 30 Mar 2022 12:34:02 GMT

Would still love this to be fixed as we have several clients with multiple data models of surveys within SDE containing 100s of relates which we must scroll through each time we connect to SDE directly to access data.

Have not yet found a way to even hide/filter relationship classes in Pro, but this would be a good interim solution if there were a way.

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

YannickBourone — Thu, 01 Feb 2024 14:25:27 GMT

In ArcGis Pro open the Options Menu -> Catalog Browsing -> Browse projet items -> List only objects owned by the connecting user

This setting hides relationship classes from other users in Arcgis Pro

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

Bud — Thu, 01 Feb 2024 15:09:52 GMT

@YannickBourone

Interesting. Although in cases like mine, my connections legitimately include tables from other users. So the "List only objects owned by the connecting user" setting would exclude those tables, which wouldn't be what I'd want.

Re: Hide relationship classes, feature datasets, and topo dsets from appearing across all schemas

DeanMoiler — Thu, 01 Feb 2024 15:51:57 GMT

@YannickBourone

Very useful to know is available! I wasn't aware of this capability, thanks for bringing to our attention. As with @Bud we've got content shared with particular DB users to bring content together (e.g. PORTAL_VIEWER), that are then shared as services. With this option the viewer user ends up with no content, so filtering display of content types would be fantastic for our workflows. Thanks for sharing!