Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Grant VIEW DEFINITION Permission Across Schemas - SQL Server

RSS
Modified on Mon, Oct 27, 2008, 5:06 PM by Administrator Categorized as SQL Server
The following T-SQL statement will grant view definition permission on the dbo schema to everyone who has access to the database.

grant view definition on schema::dbo to public

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.