Skip to content

Instantly share code, notes, and snippets.

@vgerbase

vgerbase/db_executor.sql

Last active May 13, 2016 21:19
Show Gist options
  • Save vgerbase/94fe6df4ad7e565cdc0ee61e2e0b5182 to your computer and use it in GitHub Desktop.
Save vgerbase/94fe6df4ad7e565cdc0ee61e2e0b5182 to your computer and use it in GitHub Desktop.
Download ZIP
Script to create a role to grant execute permission in all stored procedures
Raw
db_executor.sql
-- Create a db_executor role
CREATE ROLE [db_executor] AUTHORIZATION [dbo];
-- Grant execute rights to the new role
GRANT EXECUTE TO [db_executor];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment