TechBrothersIT is the blog spot and a video (Youtube) Channel to learn and share Information, scenarios, real time examples about SQL Server, Transact-SQL (TSQL), SQL Server Database Administration (SQL DBA), Business Intelligence (BI), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Warehouse (DWH) Concepts, Microsoft Dynamics AX, Microsoft Dynamics Lifecycle Services and all other different Microsoft Technologies.
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] GO GRANT EXECUTE ON[dbo].[Proc_AllCustomer]TO[TECHBROTHERS\kscott] GO
How to Grant Execute Permission on Stored Procedure to a User in SQL Server