Skip to content

Instantly share code, notes, and snippets.

@justinyoo

justinyoo/create-dbo.sql Secret

Created April 11, 2016 11:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save justinyoo/e447b39019f437be802b3d96847f6dbc to your computer and use it in GitHub Desktop.
Save justinyoo/e447b39019f437be802b3d96847f6dbc to your computer and use it in GitHub Desktop.
Download ZIP
Azure SQL Pro Tip - Creating Login Account and User
Raw
create-dbo.sql
CREATE USER [<LOGIN_ACCOUNT>] FOR LOGIN [<LOGIN_ACCOUNT>] WITH DEFAULT_SCHEMA=[dbo]
ALTER ROLE [db_owner] ADD MEMBER [<LOGIN_ACCOUNT>]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment