I have two data owners: an SDE user that owns the metadata/MM tables and a data owner for everything else.
Here's my typical upgrade steps (and this assumes a deleted version tree with only the DEFAULT version left):
1. As the SDE user, set the DEFAULT version to Public (if it's not already)
2. As the SDE user, run "Create ArcFM Solution System Tables" tool
3. As the data owner, run the "Upgrade ArcFM Solution Database" tool
4. As the data owner, run the "ArcFM Solution Object Convertor" on all feature datasets/tables that need to be "ArcFM'ified"
5. As the SDE user, reset the DEFAULT version to Protected (if this is how you handle DEFAULT)
I don't think there would be any issue with repeating steps 3 and 4 multiple times for the other data owners. It's not like there is a limit to how many times you can run the process and if the database thinks it is already done, it will tell you that it's already upgraded.
Hopefully you have a test server to try this all out on.
I also got this reply to a ticket for this same topic:
Thanks for contacting Schneider Electric ArcFM support.
This "single owner" requirement has been around for a few versions. example:
We don't test or support upgrading with DB users who are less than global owners, but that does not mean they will not work. The fact that your ArcFM solution has been working indicates that you have been doing it in a way that is effective.
My suspicion is that the Upgrade ArcFM Solution Database tool alters the MM_ tables and leave the ESRI tables alone, so being the owner of these is probably the critical factor.
Please let me know if you have further comments or questions.
The "Create/Update ArcFM Solution System Tables" tool is the one that modifies the MM_ tables and you definitely have to be logged in as that owner to make it work right.
As far as I have found, the "Upgrade ArcFM Solution Database" really only changes the version number of ArcFM stored whatever they store that in the database. That's why it usually only takes a few seconds to run.
This tool updates your geodatabase with modifications required by the latest release. This functionality makes modifications for all ArcFM Solution applications. You must be signed in as the data owner (of the business tables) to upgrade the database. When using this tool, all other users must be disconnected from the database. If another user is connected, you will receive an error message.