Team Member Permission under Azure Work or School Account
Azure Work or School Account is the new name of old Azure Organization Account. About how to set a team member to use Azure under Visual Studio Enterprise with MSDN subscription (old name was Visual Studio Ultimate subscription), I forwarded previously this link to our company's subscription administrator.
Grant Permissions on Stored Procedure
After you finished your Stored Procedures, you have to know you should grant permissions to database users, otherwise, when you deploy your application, you might find your stored procedures can not work due to permissions issues.