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. JWhite001January 29, 2022 at 9:21 AM

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

    ReplyDelete
  2. WebOctober 18, 2022 at 7:47 AM

    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

Subscribe to: Post Comments (Atom)