ArcGIS Pro 2.6.8; Oracle 18c 10.7.1 EGDB:
Scenario:
I.T. (owner=ITS) and the Engineering Department (ENG) co-manage a ROADS feature class.
- The FC is stored in the ITS owner.
- The FC uses a ROAD_NAME domain for a NAME field. The ROAD_NAME domain is owned by ITS.
Engineering wants to add some new road names to the ROAD_NAME domain, but can't since it's owned by I.T..
So Engineering staff need to submit a ticket to I.T. to get the new values added to the domain, which is a tedious process, considering how many new roads are built each year, scattered throughout the year.
Idea:
Allow ITS to give the ENG owner UPDATE privileges for the STNAME domain (create new values and edit existing values).
Note: This example has been simplified. In reality, the ENG owner (an ENG .sde connection in Catalog) doesn't have edit privileges for the ROADS FC. Instead, specific staff in the Engineering department use an OS Authentication .sde connection to edit the ROADS FC, via an editing role. I'm not an expert on Oracle privileges terminology; hopefully I got that right.
Edit: I don't want to transfer ownership of the domain to Engineering.
I.T. still wants to own that domain; they use it for other purposes and are the true owners of the FC and domain.
I suppose the Use SDE table as Domain Table idea could help with this issue. If the domain were stored as a table, then it would be easy to assign appropriate privileges to the table.
