Depending on the tasks to be performed, you may need different permissions on the MDT DB. Table 180 lists the types of tasks to be performed and the corresponding SQL Server server roles and database roles required to perform them.

Table 180. Roles and Required Roles

To perform this task

You need these roles

Create a new MDT DB from an existing database

db_owner database role in the MDT DB

Create a new MDT DB and database at the same time

sysadmin or dbcreator server role in the SQL Server instance in which the MDT DB resides

Connect to an existing MDT DB

db_datareader database role in the MDT DB or rights to the individual tables and views in the MDT DB

Modify the schema of the MDT DB

db_ddladmin database role in the MDT DB

Modify the configuration information stored in the MDT DB

db_datawrite database role in the MDT DB or rights to the individual tables and view in the MDT DB

View the configuration information stored in the MDT DB

db_datareader database role in the MDT DB or rights to the individual tables and views in the MDT DB

 

For more information on how to assign these permissions see Identity and Access Control (Database Engine).

Related Topics

Preparing the MDT DB