I created a new M:N relationship class in our SQL 2010 Enterprise Geodatabase using ArcGIS 10.6.1. The relationship class was created using a data owner connection. When I try a view these feature classes in a viewer or editor connection to the geodatabase, I get the following error: Open Failed, Error opening feature class, Insufficient permissions. Then it lists the name of the relationship class and STATE_ID = 0.
This error only occurs on the feature classes that participate in the relationship class. I then revoke the privileges, click Apply, and then grant privileges again. Once I do this, it removes the error. I am wondering if this is a common error and known workflow to do a refresh of the geodatabase privileges every time a relationship class is created?