Msg 4606 Level 16 State 1 Line 1 Granted or revoked privilege SELECT is not compatible with object.

Posted on : 29-05-2012 | By : Devi Prasad | In : Msg 4606

0



Error Message:

Msg 4606, Level 16, State 1, Line 1
Granted or revoked privilege SELECT is not compatible with object.

This error occurs when you try to grant or revoke select permissions on stored procedure.
You cannot revoke/grant Select permission on the procedure.

Example:

GRANT SELECT ON OBJECT::dbo.test TO AAAAAA 

where dbo.test is a stored procedure
Fix:
– Remove SELECT in the query and give any of the below permissions as required.

GRANT ALTER ON OBJECT::dbo.test TO AAAAAA 
GRANT CONTROL ON OBJECT::dbo.test TO AAAAAA
 
GRANT EXECUTE ON OBJECT::dbo.test TO AAAAAA 
GRANT TAKE OWNERSHIP ON OBJECT::dbo.test TO AAAAAA 
GRANT VIEW DEFINITION ON OBJECT::dbo.test TO AAAAAA 

Refer to the below link to learn more about permissions on Stored Procedures
Permissions On Stored Procedures in SQL Server




Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: , , , ,