
System-Assigned vs User-Assigned Managed Identity in Azure
Learn the difference between system-assigned and user-assigned managed identities in Azure, including lifecycle, sharing, Azure SQL, Key Vault, and common use cases.

Learn the difference between system-assigned and user-assigned managed identities in Azure, including lifecycle, sharing, Azure SQL, Key Vault, and common use cases.

Learn how to connect a Python Azure Function to Azure SQL Database using managed identity and Microsoft Entra authentication without storing database credentials.

Managed identity in Azure simplifies access management by automatically associating service principals with resources, like creating apps in Microsoft Entra when setting up a data factory. It facilitates secure access to Azure SQL without managing credentials, supporting Azure AD authentication at no extra cost. Azure offers both system-assigned and user-assigned managed identities, with the latter being customizable in the Azure portal. This technique enhances security and ease of management in Azure environments.
| Cookie | Duration | Description |
|---|---|---|
| cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
| cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
| cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
| cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
| cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
| viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |