Tuesday, November 8, 2016

SQL Server: Grant EXECUTE Permission to Store Procedure

EXECUTE

USE [DBName];
GRANT EXECUTE ON OBJECT::[dbo].[SP_Name]
    TO UserName;
GO

SELECT

USE [DBName];
GRANT SELECT ON OBJECT::[dbo].[Table_Name]
    TO UserName;
GO

No comments: