0

Is it possible thru RBAC (Role Based Access) to control who can use the reset password feature on the an Azure SQL Server in the Azure Portal

enter image description here

Jared
  • 175
  • 1
  • 13

1 Answers1

1

I tried to reproduce the same in my environment to Control Password Reset on Azure SQL DB.

I have assigned Reader Role on Azure SQL DB as below.

Open Azure SQL DB > Access control (IAM) > Add > Add Role Assignment > Reader.

enter image description here

When I try to reset the password with the same user, getting the below error.

enter image description here

Assigned contributer role to the group for managing Azure SQL DB

Created a group and assigned members to the group as below.

enter image description here

Role Assignment to group

enter image description here

Now I'm able to reset the Azure SQL DB password as below.

Whoever is part of the group can be able to reset the Azure SQL DB password.

enter image description here

Venkat V
  • 2,197
  • 1
  • 1
  • 10