Determine which user is assigned to which role Run this on your target database in Azure (ie: not against the master database) select m.name as Member, r.name as Role from sys.database_role_members inner join sys.database_principals m on sys.database_role_members.member_principal_id