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
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:
Post a Comment