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

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"];