azure – SQL Database create table permission denied

When I tried to create a table in the master database, I got the same error as shown below:

Grant permission to the user to resolve the error using the code below:

USE Master;
GRANT CREATE TABLE TO <user>;

After granting the permission, I am able to create a table in the master database:

But, as per this,

The master database is a system database – it’s not really for you to poke around in and store stuff. We usually design different backup & recovery processes for the master database as opposed to user databases.

It’s better to create tables in a dedicated database. For more information, you can refer to this.