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?
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
CREATE USER [<RO username>] FOR LOGIN [<RO username>] WITH DEFAULT_SCHEMA=[<UN schema name>]
GRANT SELECT ON SCHEMA :: [<UN schema name>] TO [<RO username>]