locked
Add a user directly to database? RRS feed

  • Question

  • Is there a way to add a user directly to the MDS database?   It looks like you could to the tblUser, but, not sure what other tables are involved to grant them the appropriate roles...
    Tuesday, January 18, 2011 7:29 PM

Answers

  • I actually updated the SID and user name in the table directly and was able to get in...we were blocked from the MDS UI until we did it...
    Thursday, February 10, 2011 4:08 AM
  • Hello longhorn

    It is probably possible, but not recommanded at all, because multiple tables involment can be hard to manage directly in SQL

    You could maybe use the API instead, but the easiest way is to use the MDS web interface

     

     


    Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem. _________________________________________________________ Regards, Xavier Averbouch, Consultant, Avanade France
    Wednesday, January 19, 2011 11:07 AM

All replies

  • Hello longhorn

    It is probably possible, but not recommanded at all, because multiple tables involment can be hard to manage directly in SQL

    You could maybe use the API instead, but the easiest way is to use the MDS web interface

     

     


    Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem. _________________________________________________________ Regards, Xavier Averbouch, Consultant, Avanade France
    Wednesday, January 19, 2011 11:07 AM
  • I actually updated the SID and user name in the table directly and was able to get in...we were blocked from the MDS UI until we did it...
    Thursday, February 10, 2011 4:08 AM