topic Relationship Classes appear across all schemas in Data Management Questions

Relationship Classes appear across all schemas

ChadMarch1 — Wed, 13 Nov 2013 21:36:38 GMT

I've got some relationship classes I created in one schema, but they appear across all schemas even though my schemas don't have general viewer access to the whole database. Anybody know why and what I can do to make sure they appear only in their schema or general viewer accounts?

ArcGIS 10.1 sp2, SQL Server 2012, Windows Server 2012

Re: Relationship Classes appear across all schemas

AsrujitSengupta — Thu, 14 Nov 2013 02:27:56 GMT

Chad,

The behavior you are observing is by design.

The below article mentions Feature Datasets, but that seems to be true for Relationship classes as well:
http://support.esri.com/es/knowledgebase/techarticles/detail/22721

You can have a look at the below scripts though:
�?� http://arcscripts.esri.com/details.asp?dbid=13428
�?� http://arcscripts.esri.com/details.asp?dbid=13886

Regards,

Re: Relationship Classes appear across all schemas

MarcoBoeringa — Thu, 14 Nov 2013 03:54:56 GMT

You can have a look at the below scripts though:
�?� http://arcscripts.esri.com/details.asp?dbid=13428
�?� http://arcscripts.esri.com/details.asp?dbid=13886

It is doubtful if these tools will work in 10.x, since they were designed for 9.x, and the geodatabase system tables underwent major changes from 9.x to 10.x (conversion to XML based), most likely rendering the suggested solutions useless.

Re: Relationship Classes appear across all schemas

AsrujitSengupta — Thu, 14 Nov 2013 18:06:58 GMT

Marco,

I didn't give those links as solution/workaround for the behavior...those are just for reference..

Regards,