Create User Group in Azure using Azure CLI (powershell)

Steps1 - Login to the azure account with  right account with azure AD access. 

Step 2 - Open CloudShell by clicking the icon on the top right corner.

Step 3 - You'll need to associate CLI session with a Storage account. So follow the instruction and connect with the storage account. 

Step 4 - Select the PowerShell in the dropdown window 

You'll see something like this screenshot:

Step 5 - type the below command and press enter:

 PS /home/sanjeeb> Connect-AzureAd

 Step 6 - type the below code (change the group name as your need):

PS /home/sanjeeb>New-AzureADGroup -Description "siteadmingroup" -DisplayName "siteadmingroup" -MailEnabled $false -SecurityEnabled $true -MailNickName "siteadmingroup"

On success, you'll see the object id like below: 

ObjectId                             DisplayName             Description

--------                             -----------             -----------

daf23147-8123-dc23-bsb8-d2d2a5224271 siteadmingroup siteadmingroup

Create Azure SQL User and add a sql role

I wanted to add a new sql user "sqluser" in Azure SQL server to access a database "sanjeeb". 

Steps to create a new SQL user. 

1) Connect to the Azure sql server with existing user using Microsoft SQL Server Management studio

2) Open new query window under Master database

3) Run the below script
    
    CREATE LOGIN [sqllogin] WITH PASSWORD = 'verystrongpassword#1' 
   

4) Open new query window under database "sanjeeb"

5) Run the below script

CREATE USER [sqluser]

FOR LOGIN [sqllogin]

WITH DEFAULT_SCHEMA =  dbo

GO

-- Add user to the database owner role

EXEC sp_addrolemember N'db_owner', N'sqluser'

GO

6) You've now created a user login "sqllogin", user account "sqluser" and added the user to "db_owner role"

7) Connect to the database using the new user login account. 

login: sqllogin

password:verystrongpassword#1

8) Click Options and select Connection properties tab

9) input Connect to database = sanjeeb

10) Click connect