Skip to content

Instantly share code, notes, and snippets.

@andreasbotsikas

andreasbotsikas/GrantExecute

Created March 23, 2014 19:36
Show Gist options
  • Save andreasbotsikas/9728585 to your computer and use it in GitHub Desktop.
Save andreasbotsikas/9728585 to your computer and use it in GitHub Desktop.
Download ZIP
Grant execute on schema (SQL Server)
Raw
GrantExecute
GRANT EXECUTE ON DATABASE::DatabaseName TO SomeRoleOrUser;
GRANT EXECUTE ON SCHEMA::dbo TO SomeRoleOrUser;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment