Unable to load or edit feature classes after creating a geometric network or network dataset in ArcMap

Description

Users granted the select and modify (update, insert, and delete) dataset privileges are not able to load or edit a feature class in ArcMap when a new geometric network or network dataset is created. Attempts to load a feature class in ArcMap return one of the following error messages:

Error:   
Error opening feature class.
The table was not found.
DBMS table not found.

Error:   
Could not add the specified data object to the map.
The table was not found.
DBMS table not found.

Error:   
Error opening feature class.
The feature class participates in a geometric network that could not be opened.
DBMS table not found.

Error:   
Could not add the specified data object to the map.
The feature class participates in a geometric network that could not be opened.
DMBS table not found.

Cause

Creating a geometric network and network dataset generates additional underlying network tables within the geodatabase. Although users are assigned the required privileges to access the dataset, the privileges are not valid for the newly generated network tables.

Solution or Workaround

To solve this issue, revoke and grant privileges to the dataset that hosts the geometric network.

Revoke and grant the privileges in ArcGIS Desktop

Use the Privileges dialog box to revoke and grant the INSERT, UPDATE, and DELETE privileges to the geometric dataset once it is created. For more information, refer to ArcMap: Use the Privileges dialog box.

Revoke and grant the privileges using SQL Server Management Studio

Use SQL Server Management Studio to grant SELECT, INSERT, UPDATE, and DELETE privileges to the underlying network tables. For more information, refer to Microsoft: GRANT Object Permissions (Transact-SQL).