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
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.
Set up a SQL Agent job and schedule it to run when desired.
ReplyDeleteThis 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