Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer 1

From Copying Databases in SQL Azure

Permissions

In order to copy a database in SQL Azure, your login requires the following permissions:

On both servers: The login must have the same login name and password on both SQL Azure servers.

On the destination server: The login must be a member of the server-level dbmanager role. Note: the server-level principal of your SQL Azure server is not a member of the dbmanager role, but automatically has the same permissions. For more information about managing logins in SQL Azure, see Managing Databases and Logins in SQL Azure.

On the source server: The login must be the DBO of the source database. Only the login that created the source database, the DBO, can copy that database to another database on the same server or on a different server.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.