Skip to content

Instantly share code, notes, and snippets.

@win2000b
Created October 18, 2016 15:05
Show Gist options
  • Save win2000b/06d7a3b5b0a5815f6176d20ba4774eb0 to your computer and use it in GitHub Desktop.
Save win2000b/06d7a3b5b0a5815f6176d20ba4774eb0 to your computer and use it in GitHub Desktop.
Creates a new role in SQL and grants the execute rights on it. So it can run SSIS packages
/* CREATE A NEW ROLE */
CREATE ROLE db_executor
/* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO db_executor
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment