SOLVED

Policy to Prevent Azure SQL Scaling ?

%3CLINGO-SUB%20id%3D%22lingo-sub-3358376%22%20slang%3D%22en-US%22%3EPolicy%20to%20Prevent%20Azure%20SQL%20Scaling%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3358376%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20create%20an%20Azure%20Policy%20to%20be%20applied%20on%20different%20Azure%20SQL%20databases%3F%3C%2FP%3E%3CP%3EThe%20policy%20wouldn't%20allow%20users%20to%20scale%20up%2Fdown%20databases%20with%20the%20exception%20of%20a%20user%2Fgroup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3374168%22%20slang%3D%22en-US%22%3ERe%3A%20Policy%20to%20Prevent%20Azure%20SQL%20Scaling%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3374168%22%20slang%3D%22en-US%22%3EYou%20could%20try%20creating%20a%20custom%20RBAC%20role%20that%20allows%20people%20to%20manage%20the%20SQL%20resources%20and%20apply%20them%20to%20the%20database%20resources%20individually.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3387081%22%20slang%3D%22en-US%22%3ERe%3A%20Policy%20to%20Prevent%20Azure%20SQL%20Scaling%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3387081%22%20slang%3D%22en-US%22%3EI%20ended%20using%20AAD%20Groups%20to%20tackle%20this%20as%20there%20is%20no%20policy%20options%20regarding%20Azure%20SQL%20scaling.%20Thanks%3C%2FLINGO-BODY%3E
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