USE MyDatabase
GO
— Windows 2000 / XP
— Replace "{servername}" with your SQL Server name
EXEC sp_grantlogin [{servername}\ASPNET]
EXEC sp_grantdbaccess [{servername}\ASPNET], [NETAPP]
— GRANT EXECUTE ON [ProcedureName] TO [NETAPP]
grant exec on [dbo].[usp_My_Procedure] TO NETAPP
GO
— Windows Server 2003
— Info.
EXEC sp_grantlogin [NT AUTHORITY\NETWORK SERVICE]
EXEC sp_grantdbaccess [NT AUTHORITY\NETWORK SERVICE]
GRANT EXECUTE ON [ProcedureName] TO [NT AUTHORITY\NETWORK SERVICE]
GO