Add New user to you Azure SQL Database and assign owner Permission.

Brass Contributor

Creating user and permission:

must run on "Master" DB

CREATE LOGIN ["username"]WITH PASSWORD=' "Password" ';

Must run on "Master" & "Database" 

CREATE USER ["UserName"]FROM LOGIN ["username"]WITH DEFAULT_SCHEMA=dbo;

only Run on "Database"

ALTER ROLE db_owner ADD MEMBER ["Username"];

0 Replies