Add user to Azure SQL Db

— On Master DB
CREATE LOGIN test
WITH PASSWORD = ‘340$Uuxwp7Mcxo7Khy’

— On Cutom DB
— add user
CREATE USER [test]
FOR LOGIN [test]
WITH DEFAULT_SCHEMA = dbo;

— add user to role(s) in db
ALTER ROLE db_owner ADD MEMBER [test];

https://www.mssqltips.com/sqlservertip/5242/adding-users-to-azure-sql-databases/

Azure CLI vs Powershell?

Azure CLI is open-source and platform independent. It works on Windows, Mac, Linux. But, from Jan 2018 even PowerShell can be used on other platforms.

https://stackoverflow.com/questions/45585000/azure-cli-vs-powershell

 

Azure Resource providers and types

When deploying resources, you frequently need to retrieve information about the resource providers and types. In this article, you learn to:

• View all resource providers in Azure
• Check registration status of a resource provider
• Register a resource provider
• View resource types for a resource provider
• View valid locations for a resource type
• View valid API versions for a resource type

You can perform these steps through the portal, PowerShell, or Azure CLI.

https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-manager-supported-services