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

2 comments:

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

    ReplyDelete
  2. This video demonstrates best practices of creating user defined database roles, how to add users to newly created database roles, how to add database objects to a https://testmyspeed.onl/ database role.

    ReplyDelete