Skip to content

Instantly share code, notes, and snippets.

@ploegert

ploegert/SQLAzure-CreateUserandAddRoles.sql

Last active August 29, 2015 14:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ploegert/223f05a98e6fc6dd6d37 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ploegert/223f05a98e6fc6dd6d37 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Azure Create User and Add Permissions
Raw
SQLAzure-CreateUserandAddRoles.sql
CREATE LOGIN TableauReader WITH password='1231!#ASDF!a';
CREATE USER TableauReader FROM LOGIN TableauReader;
CREATE ROLE db_execute
GRANT EXECUTE TO db_execute
exec sp_addrolemember 'db_execute', 'TableauReader'
EXEC sp_addrolemember 'db_ddladmin', 'TableauReader';
EXEC sp_addrolemember 'db_datareader', 'TableauReader';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment