Changing System Admin in MDS database RRS feed

  • Question

  • So the consultant who created our MDS database has left but his account is still the system admin. I looked everywhere online on how to change the old admin and it suggested everywhere to do it through udpSecuritySetAdministrator  stored procedure but the problem for me is that I cannot find the udpSecuritySetAdministrator in the MDS database. I looked everywhere in the database but it simply does not exist and I even created a new MDS database and stored procedure still does not exist. Any suggestions? Thanks!
    • Edited by Wael Morsy Friday, September 6, 2019 4:51 PM
    Friday, September 6, 2019 4:50 PM