I am a new hire and I'm in the process up setting up my database connections and default instance. I set up my personal database connection to the server under my name.

I received a MXD from a coworker and saved it on my computer. In the layer properties source tab, the data source shows that the user name is still under my coworkers name.

I would like to change the user name to my name in the source data.

Is there anyway to change the user name for this, and perhaps all of the layers at once?

I want to reset the user name here

  • 1
    It's not possible to change the owner of a table registered with the geodatabase. The supported mechanism is to GRANT SELECT access to the table as the other user to the desired owner, copy the table contents as that owner, then DROP the original table. – Vince Oct 24 '16 at 23:34

You can re-point your layers to another connection using Set Data Sources in ArcCatalog

enter image description here

In the dialog that opens, select all the layers you need to update, and choose Replace All

enter image description here

In the Replace All dialog, in the second field add the path to your new connection (as per your comment I set up my personal database connection to the server under my name)

enter image description here

When you OK it will update the New Data Source for all the layers, and another OK will create a new MXD pointing at your database connection, and therefore using your connection username properties.

enter image description here

| improve this answer | |
  • I agree this should work. It appears to "replace all" user names in arc catalog when I follow these steps, but when I go back into my (new copy of the original) mxd, the user names are still set to my coworker who sent me the mxd. Hmmm. – Kelly Rogers Oct 25 '16 at 12:45
  • I spoke too soon. This worked!! Thank you so much!! Forgive me, I am not a computer scientist, I am an environmental scientist! The first time I messed this up by only changing the user name in the – Kelly Rogers Oct 25 '16 at 13:15
  • in the "new data source". See # 1 below in the photo. This did not work. The second time, I changed the entire file path. See # 2 below in the photo. This obviously worked. – Kelly Rogers Oct 25 '16 at 13:19

User Name Change Solution

In Arc Catalog, right click the MXD and Set data source. See # 1 below in the photo. Only changing the user name here did not work. # 2 below in the photo I changed the entire file path. This obviously worked. Thanks for the comments!!! Aloha!

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.