Tech Junkie Blog - Real World Tutorials, Happy Coding!: ASP.NET SQL Server: Granting Access Permissions to Stored Procedures For IIS Part 8

Tuesday, February 17, 2015

ASP.NET SQL Server: Granting Access Permissions to Stored Procedures For IIS Part 8

In SQL Server type in the following command in the Query Window:

USE Northwind;
Grant EXEC ON OBJECT::dbo.GetProducts TO "NT AUTHORITY\NETWORK SERVICE";
GO

The command above grants execution permission for user "NT AUTHORITY\NETWORK SERVICE" on the stored procedure dbo.GetProducts

dbo = owner schema
GetProducts = name of stored procedure
"NT AUTHORITY\NETWORK SERVICE" = user that IIS uses to access SQL Server



Blogs In the T-SQL Series:

1 comment:

Search This Blog