Azure SQL Server DBA

Identity, Security & Compliance, Azure-specific

Question

Microsoft Entra administrator vs Microsoft Entra database principal: what differs?

Answer

The administrator bootstraps Entra access on an Azure SQL logical server or Managed Instance. A mapped database user or login receives database permissions. Set a recoverable Entra administrator first; grant application and operator access through least-privileged principals thereafter.

This is 3 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples