Users and Logins in Azure SQL Databases | 🔥 Free Azure SQL DBA Training 🔥

There are only two types of roles available in azure SQL compared to the on-prem SQL servers.
1. Login Manager
2. DB Manager
Also, In azure SQL you can create a user without login.
Please link and share the video so that the maximum people get aware of the Azure SQL
Join the group: t.me/sqlbrainbox
Azure SQL DBA Videos: kzbin.info?list...
Create an Azure Account: azure.microsoft.com/en-in/free/
Azure Document:docs.microsoft.com/en-in/azur...
#azuresql #sql #database

[@santoshkumarc2444]

Thanks for great explanation

[@Niravgandhi]

You are welcome!

[@GaneTcr]

Sir, as sqladmin is sql login with admin access during create sql server, then why we cant run create user command and you specifically grant AD admin on sql server to Mike?

[@gaurangranpariya2470]

Great explanation.. ☺

[@Niravgandhi]

Thanks 🙂

[@neelnono]

Hello Nirav, Can you post a video which uses AD authentication to connect DB? I am interested in how my AD users can directly connect to Db without credentials

[@rajusangam7480]

How to get the logins with permission details

[@kundangaikwad1700]

Hi Nirav, What privilege's does Active directory admin user has on Azure level and on database level? and how to create windows ad user in Azure SQL database?

[@Niravgandhi]

Not getting you

[@mohammadhaider6877]

Hi Nirav, thanks for this video, It's very useful. is there anyway if we can grant dbmanager or loginmanager access to AD user group?

[@Niravgandhi]

Yes

[@Niravgandhi]

Yes, you can

[@TejasPatil-fz6bo]

Why don’t we see GUI in azure sql unlike on Prem ?

[@Niravgandhi]

No idea