Utility network priviledges

193
2
04-22-2020 04:18 AM
FilipKuzman
New Contributor III

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

0 Kudos
2 Replies
AnthonyRyanEQL
Occasional Contributor III

Filip,

I'm working on a Utility Network project and we have created a read only user within SQL Server 2016 to access the schema that the utility network resides in.

This was development by our implementation partner

SQL to execute

USE [<db_name>]
CREATE USER [<RO username>] FOR LOGIN [<RO username>] WITH DEFAULT_SCHEMA=[<UN schema name>]
GRANT SELECT ON SCHEMA :: [<UN schema name>] TO [<RO username>]

Good luck

FilipKuzman
New Contributor III

That worked! 

Thank you Anthony.

0 Kudos