First of all, you need to add an Azure Active Administrator to the SQL

In SQL studio to add user/groups:

CREATE USER [Team_xyz] FROM EXTERNAL PROVIDER;
EXEC sp_addrolemember db_owner, [Team_xyz];