How to Provide Execute Permission to specific Store Procedures to a User in a Database of SQL Server - SQL Server DBA Tutorial

This video shows step by step process of how to give store procedure execute permission to a user using SQL Server Management studio as well as using T-SQL Script. It also talk about best practices of providing permissions to a database user using securables as well as user window. It also demonstrates if underneath tables of a store procedure needs to be added in user permissions.

Script for : Execute permission on Stored Procedure to User
USE [SalesOrders]
GRANT EXECUTE ON [dbo].[Proc_AllCustomer] TO [TECHBROTHERS\kscott]

How to Grant Execute Permission on Stored Procedure to a User in SQL Server

1 comment:

  1. Set up a SQL Agent job and schedule it to run when desired.