This script changes the Referenced Owner/Schema of Synonyms. This Schema does not need to be created on MR. To change this, you only need to specify which owner you want to change and what is the new owner name. Just look at the code and you'll see where to input that. Here's an example: I have this Synonym: create or replace synonym Schema001.SYN_TBL_TEST for Schema002.TBL_TEST; Now, i want to change the Schema002 name. So i change the following lines: fromUser = "Schema002" toUser = "NewSchema003" Then i run it. Done! The synonym will be like this: create or replace synonym Schema001.SYN_TBL_TEST for NewSchema003.TBL_TEST; Sub Evaluate_OnLoad Dim DeUsuario Dim ParaUsuario Dim Refob Dim OwnerRef Dim OwnerObj '******************************* '* Change the String Bellow '******************************* fromUser = "" toUser = "" '****************************** Set Context = CreateObject("SCF.ScriptContext") Set Framework = CreateObject("SCF.ScriptFramework") Set Document = Context.ScriptDocument Set ThisScript = Context.Object Set Model = ThisScript.Model Set ModelObject = Model.AsObject Set Sinonimos = ModelObject.Children("Synonym") ' Document.Write("------ Sinonimos -------" & vbCRLF) ' Model.BeginTransaction("Change the Owner Referenced Object") For Each S In Sinonimos If S.hasProperty("Referenced Object Text")=True then Refob = S.Property("Referenced Object Text").AsString OwnerRef = Mid(Refob,1,InStr(Refob,".")-1) OwnerObj = Mid(Refob, InStr(Refob,".")+1, Len(Refob)) If OwnerRef = fromUser Then Set PropValue = Framework.CreatePropertyValue("Synonym","Referenced Object Text") PropValue.FromString(toUser & "." & OwnerObj) Call S.SetProperty("Referenced Object Text",PropValue) Document.Write(S.Name & " Altered." & vbCRLF) End If End If Next Model.EndTransaction() End Sub