Skip to content

Instantly share code, notes, and snippets.

@justinyoo
Created April 11, 2016 12:53
  • 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/8f910737a59677bf3f0f7a82787c318a 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 ('GRANT SELECT,INSERT,UPDATE,DELETE ON SCHEMA::dbo TO [' + @Username + ']')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment