Skip to content

Instantly share code, notes, and snippets.

@justinyoo
Created April 11, 2016 12:52
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save justinyoo/29d2c173d7c76838be44b329615bd4d2 to your computer and use it in GitHub Desktop.
DevOps Pro Tip - Creating Accounts on Azure SQL Database through PowerShell
EXECUTE ('CREATE USER [' + @Username +'] FOR LOGIN [' + @Username + '] WITH DEFAULT_SCHEMA=[dbo]')
EXECUTE ('ALTER ROLE [db_owner] ADD MEMBER [' + @Username + ']')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment