Currently have 2 users in our SQL Azure subscription. One is the god login created when setting up the server, other is very limited account for our www app (has db_datareader and db_datawriter).
The www user does not have enough privileges to use the SQL Azure Migration Wizard. Connecting to server shows the db as grayed out / disabled.
I want to create a 3rd user with just enough privileges to use the mw for copy / backup. What roles / privileges does this user need? Does anyone have some prepared sql scripts?