CREATE USER

Users based on logins in

master

new name for Azure Active Directory (Azure AD)

Microsoft Entra server principals (logins)

ﾃ

Analytics Platform System (PDW)

SQL database in Microsoft

Fabric

Adds a user to the current database. The 13 types of users are listed with a sample of the most

basic syntax:

User based on a login based on a Windows Active Directory account.

User based on a login based on a Windows group.

User based on a login using SQL Server authentication.

User based on a Microsoft Entra login.

７

Note

While Microsoft Entra ID is the

, to

prevent disrupting existing environments, Azure AD still remains in some hardcoded

elements such as UI fields, connection providers, error codes, and cmdlets. In this article,

the two names are interchangeable.

７

Note

are currently in public preview for Azure

SQL Database.

７

Note

Logins, and therefore users based on logins, aren’t supported in SQL database in

Microsoft Fabric.

Users that authenticate at the database

Users based on Windows principals that connect through Windows group logins

Users that cannot authenticate

CREATE USER
[Contoso\Fritz];

CREATE USER [Contoso\Sales];

CREATE USER Mary;

CREATE USER [bob@contoso.com] FROM LOGIN
[bob@contoso.com]