SQL Server 2005 Not remembering Column Permissions

[KristianW]

I'm new to MS SQL 2005 and I'm currently creating a DB and assigning certian column permissions to tables. I can set certain columns to allow "SELECT" for example, but say if I add another column to this table and then try to assign SELECT permissions to it, all of my previous settings are not there anymore.

This is very frustrating, as I need to re-select ALL of the previous columns, as well as the new one. If I forget to select one I've set up previously, then when I go back to select it in Management Studio I have to select them all again!!

Surely there is some way that Management Studio can retain the previous permissions I've assigned, and not have an empty list every time I want to change a permission in the table?

Any help here would be appreciated!!

 

[KristianW]

I've worked it out - if you click the mouse on the "grant" column of the permission you want to change, then click "Column Permissions", it erases all permissions, but if you click on the permission itself (eg Select), then click the "Column Permissions" button, the settings are retained.

Bit silly, but at least it's working!