User and Password Managment in Azure SQL

Question

Hello,
We are currently using Azure SQL database for our application. For this database I want to create multiple user which would perform Admin and non Admin roles.
For all the users created we need a password manager to manage password for the Users. My boss suggested me something like Keepersecurity.com for this purpose.
While looking for possible solution around it, I found we can do this using Azure Active Directory Authentication and the users can use their windows password to access the Azure SQL database.
Can someone please help me to identify best solution to my usecase and some resources around it?

Thanks in advance!

Praneet Rane

Answer 1

If the database users are intended for application use then you can consider Azure Key Vault as explained here.

Here you will find an example of how to integrate Azure Active Directory With a Password Manager like Keeper Password Manager.

In addition, you can configure Azure Active Directory users to have access and permissions to Azure SQL databases, and perform administrative and non-administrative tasks, as explained here.