Skip to content

Instantly share code, notes, and snippets.

@justinyoo

justinyoo/create-user.sql Secret

Created April 11, 2016 11:17
Show Gist options
  • Save justinyoo/584c8d5173d81e8faa0ef0a0b88de454 to your computer and use it in GitHub Desktop.
Save justinyoo/584c8d5173d81e8faa0ef0a0b88de454 to your computer and use it in GitHub Desktop.
Download ZIP
Azure SQL Pro Tip - Creating Login Account and User
Raw
create-user.sql
CREATE USER [<LOGIN_ACCOUNT>] FOR LOGIN [<LOGIN_ACCOUNT>] WITH DEFAULT_SCHEMA=[dbo]
GRANT SELECT,INSERT,UPDATE,DELETE ON SCHEMA::dbo TO [<LOGIN_ACCOUNT>]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment