Skip to content

Instantly share code, notes, and snippets.

@vgerbase

vgerbase/db_viewdefinition.sql

Created May 13, 2016 21:20
Show Gist options
  • Save vgerbase/c3806559281ed747e5e0dc3385d5764f to your computer and use it in GitHub Desktop.
Save vgerbase/c3806559281ed747e5e0dc3385d5764f to your computer and use it in GitHub Desktop.
Download ZIP
Script to create a role to grant view definition permission in all objects
Raw
db_viewdefinition.sql
-- Create a db_viewdefinition role
CREATE ROLE [db_viewdefinition] AUTHORIZATION [dbo];
-- Grant view definition rights to the new role
GRANT VIEW DEFINITION TO [db_viewdefinition];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment