torleifhalseth/Managing database logins on Azure.md

Last active August 29, 2015 14:09

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/torleifhalseth/26c52a9d8e669029a410.js"></script>
Save torleifhalseth/26c52a9d8e669029a410 to your computer and use it in GitHub Desktop.

Raw

###Managing Database Logins -- first, connect to the master database ####Create Login

CREATE LOGIN login1 WITH password='<ProvidePassword>';

####Create User Remember to run the queries below on the actual database (Right click the database and select "New Query")

CREATE USER login1User FROM LOGIN login1;

####Assign SQL Database Server-Level Roles

EXEC sp_addrolemember 'db_owner', 'login1User';