title: Link Azure SQL Database to Data Factory using managed identity
body: <p>I have been trying to use Managed Identity to connect to Azure SQL Database from Azure Data factory.<br />
  Steps are as follow:</p>
  <ol>
  <li>Created a Linked Service and selected Managed Identity as the Authentication Type</li>
  <li>On SQL Server, added Managed Identity created for Azure Data Factory as Active Directory Admin</li>
  </ol>
  <p>The above steps let me do all data operations on the database. Actually that is the problem. I want to restrict the privileges given to Azure Data Factory on my SQL database.</p>
  <p>First,  let me know whether I have followed the correct steps to set up the managed identity. Then, how to limit privileges because I don't want data factory to do any DDL on SQL database.</p>