Skip to content

Instantly share code, notes, and snippets.

@justinyoo

justinyoo/create-dbo-dynamic-sql.sql Secret

Created April 11, 2016 12:52
Show Gist options
  • Save justinyoo/29d2c173d7c76838be44b329615bd4d2 to your computer and use it in GitHub Desktop.
Save justinyoo/29d2c173d7c76838be44b329615bd4d2 to your computer and use it in GitHub Desktop.
Download ZIP
DevOps Pro Tip - Creating Accounts on Azure SQL Database through PowerShell
Raw
create-dbo-dynamic-sql.sql
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