Otdfbt

Multi tool use

Watching the game, having a puzzle

How did Thanos not realise this had happened at the end of Endgame?

Can 'sudo apt-get remove [write]' destroy my Ubuntu?

Why do unstable nuclei form?

How to get a ellipse shaped node in Tikz Network?

Why did they go to Dragonstone?

Pre-1993 comic in which Wolverine's claws were turned to rubber?

Is it a good idea to copy a trader when investing?

What does formal training in a field mean?

Is ‘despite that’ right?

How to handle DM constantly stealing everything from sleeping characters?

Is there an application which does HTTP PUT?

Why do Thanos' punches not kill Captain America or at least cause vital wounds?

What does this quote in Small Gods refer to?

Series that evaluates to different values upon changing order of summation

Are there variations of the regular runtimes of the Big-O-Notation?

Remove color cast in darktable?

Was the Highlands Ranch shooting the 115th mass shooting in the US in 2019

cropping a message using array splits

Why are low spin tetrahedral complexes so rare?

Two researchers want to work on the same extension to my paper. Who to help?

Why does it take longer to fly from London to Xi'an than to Beijing

How are one-time password generators like Google Authenticator different from having two passwords?

What's the "magic similar to the Knock spell" referenced in the Dungeon of the Mad Mage adventure?

Allow Azure database creation ONLY inside Elastic Pool

Storing sql credentials inside an azure subscriptionWhy am I getting “RESTORE DATABASE TERMINATED ABNORMALLY” (Error 3013) when restoring from Azure Blob Storage to SQL Server 2014AD DC in azure as the only DCIssues adding new DC to network after main DC broke downAzure elastic database pool storage limit briefly drops to zeroHow do I connect to an Azure SQL Server via an Azure VPN Gateway?Azure AD allow login only within the OfficeAzure database utilisation (DTUs)What are the drawbacks of putting my staging and production dbs into one Azure Elastic Pool?Azure Database : Wrong Time Zone

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

In Azure, is there a way to create a custom role or enforce a policy to only allow users to create databases inside an elastic pool?

I tried with a custom role with the "Microsoft.Sql/servers/databases/write" in "NotActions" section, but this permission is also needed to create databases inside Elastic Pool. I have not yet tried with policies, because i'm still learning how define them.

I also tried with "SQL Server Contributor" and "SQL DB Contributor" roles, but neither suits our needs.

The idea is to restrict the creation of new single databases, Sql servers or pools to certain users.

azure

share|improve this question

edited May 1 at 3:26

womble♦

86.1k18147205

asked Apr 30 at 18:22

smartdansmartdan

12

add a comment | 

0

In Azure, is there a way to create a custom role or enforce a policy to only allow users to create databases inside an elastic pool?

I tried with a custom role with the "Microsoft.Sql/servers/databases/write" in "NotActions" section, but this permission is also needed to create databases inside Elastic Pool. I have not yet tried with policies, because i'm still learning how define them.

I also tried with "SQL Server Contributor" and "SQL DB Contributor" roles, but neither suits our needs.

The idea is to restrict the creation of new single databases, Sql servers or pools to certain users.

azure

share|improve this question

edited May 1 at 3:26

womble♦

86.1k18147205

asked Apr 30 at 18:22

smartdansmartdan

12

add a comment | 

In Azure, is there a way to create a custom role or enforce a policy to only allow users to create databases inside an elastic pool?

I tried with a custom role with the "Microsoft.Sql/servers/databases/write" in "NotActions" section, but this permission is also needed to create databases inside Elastic Pool. I have not yet tried with policies, because i'm still learning how define them.

I also tried with "SQL Server Contributor" and "SQL DB Contributor" roles, but neither suits our needs.

The idea is to restrict the creation of new single databases, Sql servers or pools to certain users.

azure

share|improve this question

edited May 1 at 3:26

womble♦

86.1k18147205

asked Apr 30 at 18:22

smartdansmartdan

12

share|improve this question

edited May 1 at 3:26

womble♦

86.1k18147205

asked Apr 30 at 18:22

smartdansmartdan

12

share|improve this question

edited May 1 at 3:26

womble♦

86.1k18147205

asked Apr 30 at 18:22

smartdansmartdan

12

edited May 1 at 3:26

womble♦

86.1k18147205

edited May 1 at 3:26

womble♦

86.1k18147205

asked Apr 30 at 18:22

smartdansmartdan

12

asked Apr 30 at 18:22

smartdansmartdan

12