Select to view content in your preferred language

Access feature class in same SDE database with different schema owner

152
2
Jump to solution
03-18-2025 09:02 AM
Dennis1
Emerging Contributor

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?  

0 Kudos
1 Solution

Accepted Solutions
MikeMillerGIS
Esri Frequent Contributor

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

View solution in original post

2 Replies
MikeMillerGIS
Esri Frequent Contributor

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

Dennis1
Emerging Contributor

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.

0 Kudos