Utility network priviledges

Question

Hi everybody,

I am trying to grant privileges in my Enterprise Geodatabase for the Utility Network dataset to the other users in SQL Server. Dataset is branch versioned. I have added users through the GP tool Create Database User in ArcGIS Pro and then assigned dbcreator role to them in SQL Manager. However, if I try to add privileges to any of them on my UN dataset(as UN owner) I got 'Unsupported operation for utility network datasets.' Even just for select option. Does the UN support multi-users on its dataset? Or am I missing something?

Thank you

PierreloupDucroix · Answer

Thanks, Robert. We primarily use the SDE connection file to export data from the default version via administrative toolboxes or scheduled tasks.

I know feature services and the Portal offer better privilege management, but in some cases, direct access to the geodatabase offers better performance than using a feature service, and I don't want to share the data owner's connection file. That's why a read-only user would be helpful.

RobertKrisher · Answer

Users should not be directly connecting to the geodatabase to access utility network data, they should be using services.

PierreloupDucroix · Answer

Hello, does anyone have more information on this?

Is this normal behavior in Utility Network? If so, why?

I've reproduced the problem with ArcGIS Pro 11.5 and PostgreSQL.

I was able to grant read access to a UN dataset via SQL, but not through ArcGIS Pro's privilege management.