Error:
EXECUTE permission denied on object ‘usp_GetEmployeeDetails’, database ‘Employee’, schema ‘dbo’.
Solution:
- Expand your database Node. For me it’s “Employee”.
- Underneath of it Expand “Security” Node.
- Click on the user which you are using for Database operations. By default it is
MACHINENAME\ASPNET [MYMACHINE\ASPNET].
- It will open the window as shown below from database Roles Select db_owner:
That’s it…