question

ZakirChougle avatar image
0 Votes"
ZakirChougle asked AlbertoMorillo edited

Type of access on Azure SQL Database

I am very new to Azure. Our client would be creating SQL database for us on their Azure portal for development purpose. To server the development need what level and type of access we should request our client to grant us on Azure so that we can easily connect, read, write to the Azure SQL database?

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

Wth a contained database SQL login that belongs to the database group db_owner you will be able to create objects, read and write data, execute permissions on programming objects.

I recommend you to use Serverless database that can be configure to auto-pause/auto-resume when not in used.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.