HDTutorial
EN
SQL Server DBA Tutorial 61-Provide Execute Permission to specific Store Procedures to a User

Playback starts YouTube’s embedded player (privacy-enhanced mode).

SQL Server DBA Tutorial 61-Provide Execute Permission to specific Store Procedures to a User

20,522 views October 26, 2015 6:07

Watch on YouTube
ChannelTechBrothersIT

Description from the creator

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.

Blog Post link
sqlage.blogspot.com/2015/03/how-to-provide-exec…

Visit our website to check out SQL Server DBA Tutorial Step by Step
techbrothersit.com/2014/12/sql-server-dba-tutor…

About this tutorial

TechBrothersIT published this 6:07 video tutorial on October 26, 2015. It has been watched 20,522 times on YouTube.

Duration
6:07
Published
October 26, 2015
Views
20,522
Likes
82

Tags

Share

Further reading

  • How to Provide Execute Permission to specific Store ... techbrothersit.com

    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…

  • Grant Permissions on a Stored Procedure - SQL Server ... docs.microsoft.com

    This topic describes how to grant permissions on a stored procedure in SQL Server 2019 (15.x) by using SQL Server Management Studio or Transact-SQL. Permissions can be granted to an existing user, database role, or appl…

  • sql - Grant execute permission for a user on all stored ... stackoverflow.com

    So far so good, however, no user has execute rights for stored procedures. I know I can use . GRANT EXECUTE ON [storedProcName] TO [userName] If it was just a few procedures, however, I have about 100 so what's the easi…

This tutorial in other languages