SOLVED

Policy to Prevent Azure SQL Scaling ?

New Contributor

Hello,

 

Is there a way to create an Azure Policy to be applied on different Azure SQL databases?

The policy wouldn't allow users to scale up/down databases with the exception of a user/group.

 

Thank you.

2 Replies
best response confirmed by BrunoIllipronti (New Contributor)
Solution
You could try creating a custom RBAC role that allows people to manage the SQL resources and apply them to the database resources individually.
I ended using AAD Groups to tackle this as there is no policy options regarding Azure SQL scaling. Thanks