topic Re: Access feature class in same SDE database with different schema owner in Attribute Rules Questions

Access feature class in same SDE database with different schema owner

Dennis1 — Tue, 18 Mar 2025 16:02:43 GMT

I am trying to create an attribute rule to populate a field with an ID attribute of an intersecting feature. My Arcade expression validates when I intersect with a feature class in the same database and with the same schema owner. In this case I am adding attribute rules to the sde.PWORKS.Sign feature class and getting attributes from the sde.PWORKS.Pole feature class. However when I try to intersect with a feature class in the same database with a different schema owner (sde.ENG.CityGrid) I receive an error that the CityGrid layer cannot be found.

Using the following to access the CityGrid layer:

var grid = FeatureSetByName($datastore, "sde.ENG.CityGrid", ["CITYGRID"], false);

Does $datastore only work if the feature class in the same database with the same owner? Is there an alternative way to access a feature class with a different schema owner?

Re: Access feature class in same SDE database with different schema owner

MikeMillerGIS — Tue, 18 Mar 2025 17:30:18 GMT

I believe the AR is executed by the Data Owner. Does the Data Owner have permissions to that table?

Re: Access feature class in same SDE database with different schema owner

Dennis1 — Wed, 19 Mar 2025 15:44:38 GMT

Yes, that was the issue. I gave the PBWORKS account view permissions on the dataset owned by ENG and the attribute rule verifies. Our user accounts have read access by default on both the public works and engineering data sets but didn't consider that our data owner accounts don't have that permission. Thank you for the help.