Adding Multiple Users to MC-managed Databases
If you are administering one or more MC-managed databases, and several MC users need access to it, you have two options on the MC Settings page:
- From the User management option, select each user and grant database access, one user at a time
This procedure describes how to add several users to one database at once. If you want to add users one at a time, see Creating an MC User.
Before You Start
Read the prerequisites in Creating an MC User.
How to Add Multiple Users to a Database
- Log in to MC as an administrator and navigate to MC Settings > Resource access.
- Choose a database from the list of discovered databases. Selecting the database populates a table with users who already have privileges on the selected database.
- To add new users, click Add and select the MC username you want to add to the database from the drop-down list.
- Enter an existing Database username on the selected database or click the ellipses button […] to browse for names. (This is the database account you want to map the selected user to.)
-
Enter the database password (not this username's password).
Note: The database password is generally the dbadmin superuser's password.
- Choose a database-access role (ADMIN or IT or USER) for this user.
- Click OK to close the Add access to resource dialog box.
- Perform steps 3-7 for each user you want to add to the selected database, and then click Save.