How to create a native login in azure

 

create login DAV4635 with password='YourPassword';

create user DAV4635 from login DAV4635;

USE AEDIDACATED

EXEC sp_addrolemember N'db_owner', N'DAV4635'

GO

__

-- ADD AD USER

  CREATE USER [dexter.soreta@aei.com] 

FROM EXTERNAL PROVIDER 

WITH DEFAULT_SCHEMA = dbo;  

EXEC sp_addrolemember N'db_datareader', N'dexter.soreta@aei.com'