Skip to content

Instantly share code, notes, and snippets.

@vkhazin

vkhazin/gist:5b713e962af3341bbf6037b7807df389

Created October 28, 2017 13:58
Show Gist options
  • Save vkhazin/5b713e962af3341bbf6037b7807df389 to your computer and use it in GitHub Desktop.
Save vkhazin/5b713e962af3341bbf6037b7807df389 to your computer and use it in GitHub Desktop.
Download ZIP
Create MS Sql Login and grant database ownership role
Raw
gistfile1.txt
USE <db name>
CREATE LOGIN <login name> WITH PASSWORD = '<password>'
create user <login name> for login <login name>
exec sp_addrolemember 'db_owner', '<db name>'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment