Granting Column Permissions to Role

[BillMoo]

Hi,

I want to be able to restrict the updates done to various columns within a table to a role, so the permissions apply to all users within the role.

This table resides in a Schema called Test but using either:

GRANT INSERT, UPDATE ON [Test].[TestTable](Stuff1, Stuff3) TO [Testers]
GO

or

GRANT INSERT, UPDATE ON [Test].[TestTable](Stuff1, Stuff3) TO [TestUser1]
GO

Produces this error:

Msg 1020, Level 15, State 1, Line 0
Sub-entity lists (such as column or security expressions) cannot be specified for entity-level permissions.

But as I read the documentation

http://msdn.microsoft.com/en-us/library/ms188371.aspx

what I am trying to do is syntactically correct.

The Schema, Role, User, Table and Columns do already exist.

I'm quite confused now.

Can anyone point me in the right direction with this please.