Skip to content

Instantly share code, notes, and snippets.

@davipviana

davipviana/create-user.sql

Last active June 10, 2020 18:43
Show Gist options
  • Save davipviana/6cb07ce8a24b6ab6e92ee604e53b77ac to your computer and use it in GitHub Desktop.
Save davipviana/6cb07ce8a24b6ab6e92ee604e53b77ac to your computer and use it in GitHub Desktop.
Download ZIP
SQL script to create user
Raw
create-user.sql
-- RUN in master database
CREATE LOGIN [any-login] WITH password='any-pwd';
-- RUN in user database
CREATE USER [any-user] FROM LOGIN [any-login];
EXEC sp_addrolemember 'db_ddladmin', 'any-user';
EXEC sp_addrolemember 'db_datawriter', 'any-user';
EXEC sp_addrolemember 'db_datareader', 'any-user';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment