none
MIM2016: permissions for database access RRS feed

  • Question

  • Hi everyone

    I read the install user of MIM needs SQL sysadmin right during installation of MIM because it will generate the database by itself.

    But what permissions does the user need after the installation? I couldn't find a definite statement about that.

    Thanks for the help.

    Tuesday, September 5, 2017 8:39 AM

Answers

  • If you are using a separate user to install versus the one who is used to run MIM Services, this users does not need anything at all.

    If you use the same user which is also the MIM User, then it needs DBO.

    Scenario 1: User=MIMINstall, MIMSync, MIMService.   Run installs as MIMInstall, but the MIMSync and MIMService are assigned as the service accounts. MIMInstall needs SA, nothing after.

    Scenario 2: MIMSync, MIMINstall. U install the components as one of these users, which requires the SA, late you can reduce to DBO.


    Nosh Mernacaj, Identity Management Specialist

    • Proposed as answer by Nosh Mernacaj Tuesday, September 5, 2017 12:53 PM
    • Marked as answer by Udeo Wednesday, September 6, 2017 3:01 PM
    Tuesday, September 5, 2017 12:53 PM