{"id":226,"date":"2012-05-29T09:15:52","date_gmt":"2012-05-29T09:15:52","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/05\/29\/msg-4606-level-16-state-1-line-1-granted-or-revoked-privilege-select-is-not-compatible-with-object\/"},"modified":"2012-05-29T09:15:52","modified_gmt":"2012-05-29T09:15:52","slug":"msg-4606-level-16-state-1-line-1-granted-or-revoked-privilege-select-is-not-compatible-with-object","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/05\/29\/msg-4606-level-16-state-1-line-1-granted-or-revoked-privilege-select-is-not-compatible-with-object\/","title":{"rendered":"Msg 4606 Level 16 State 1 Line 1 Granted or revoked privilege SELECT is not compatible with object."},"content":{"rendered":"<p><strong>Error Message:<\/strong><br \/>\n<font color=\"red\"><br \/>\nMsg 4606, Level 16, State 1, Line 1<br \/>\nGranted or revoked privilege SELECT is not compatible with object.<br \/>\n<\/font> <\/p>\n<p>This error occurs when you try to grant or revoke select permissions on stored procedure.<br \/>\nYou cannot revoke\/grant Select permission on the procedure.<\/p>\n<p><strong>Example:<\/strong><br \/>\n[sql]<br \/>\nGRANT SELECT ON OBJECT::dbo.test TO AAAAAA<br \/>\n[\/sql]<br \/>\nwhere dbo.test is a stored procedure<br \/>\n<strong>Fix:<\/strong><br \/>\n&#8211; Remove SELECT in the query and give any of the below permissions as required.<\/p>\n<p>[sql]<br \/>\nGRANT ALTER ON OBJECT::dbo.test TO AAAAAA<br \/>\n[\/sql]<br \/>\n[sql]<br \/>\nGRANT CONTROL ON OBJECT::dbo.test TO AAAAAA<br \/>\n[\/sql]<br \/>\n[sql]<br \/>\nGRANT EXECUTE ON OBJECT::dbo.test TO AAAAAA<br \/>\n[\/sql]<br \/>\n[sql]<br \/>\nGRANT TAKE OWNERSHIP ON OBJECT::dbo.test TO AAAAAA<br \/>\n[\/sql]<br \/>\n[sql]<br \/>\nGRANT VIEW DEFINITION ON OBJECT::dbo.test TO AAAAAA<br \/>\n[\/sql]<\/p>\n<p>Refer to the below link to learn more about permissions on Stored Procedures<br \/>\n<a href=\"http:\/\/sqlserverlearner.com\/2012\/grant-revoke-permissions-on-stored-procedures-in-sql-server\" target=\"_blank\" rel=\"noopener noreferrer\">Permissions On Stored Procedures in SQL Server<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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: [sql] GRANT SELECT ON OBJECT::dbo.test TO AAAAAA [\/sql] where dbo.test is&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2035],"tags":[2036,2037,2038,2039,2040],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/226"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=226"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/226\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}