You’ve just entered a new stored procedure and you run your web page which uses it and WHAM! – you get this error message. Luckily, it’s not too bad.
Just go to security->schemas-> and double click dbo. Then click on permissions on the left. Find the blue font text that says ‘View database permissions’ and click it. For each user in the upper window you want to grant execute permissions, select that user and scroll down in the bottom window for “execute”. All you have to do is click the checkbox in the ‘Grant’ column.
All Things DotNet Discussed – Winforms/ASP.Net/SharePoint/WPF