How to Provide View Definition Permission of Database Objects to a user in SQL Server - Microsoft SQL Server DBA Tutorial

This video shows step by step process of providing view definition permission of database objects to a user in SQL Server using SQL Server Management studio as well as using T-SQL Script. It covers how to provide view definition permission on tables as well as other database objects such as store procedures etc.

Script to Grant View Definition Permissions

USE [SalesOrders]
GO
 
GRANT VIEW DEFINITION ON [dbo].[Customers] TO [TECHBROTHERS\kscott]
GO

 USE [SalesOrders]
GO

 GRANT VIEW DEFINITION ON [dbo].[Proc_AllCustomer] TO [TECHBROTHERS\kscott]
GO
 
USE [SalesOrders]
GO
 
GRANT VIEW DEFINITION ON [dbo].[Customers_2] TO [TECHBROTHERS\kscott]
GO




Provide View Definition Permission of Database Objects to a User in SQL Server

No comments:

Post a Comment