Granted or revoked privilege RECEIVE is not compatible with object

Question

I am using sql server 2008 r2.

I am following this tutorial http://www.codeproject.com/Articles/144344/Query-Notification-using-SqlDependency-and-SqlCach#heading0001

This is my code

GRANT RECEIVE ON dbo.tranferToSIP TO UserName

I got this error message:

Granted or revoked privilege RECEIVE is not compatible with object.

Answer 1

I had created roles to execute the stored procedure and was trying to grant execute permission to tables. Check whether table needs a execute permission or not. In my case, it was not required to grant permissions for tables and we do not execute tables. :)