Skip to content

Instantly share code, notes, and snippets.

@richardbasile

richardbasile/createUser.sql

Last active February 16, 2018 13:51
Show Gist options
  • Save richardbasile/ae6c7350c1e557e57b022f9cd5221410 to your computer and use it in GitHub Desktop.
Save richardbasile/ae6c7350c1e557e57b022f9cd5221410 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Server - Create User
Raw
createUser.sql
create login <user name> with password = '<password>', default_database = <db name>;
create user <user name> from login <user name> with default_schema = dbo;
alter role <role> add member <user name>;
grant showplan to <user name>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment