Hi there,

In D6 if you had permissions to edit a content type you could edit the body of any node within that content type.

Now I find that in D7 if a user with Full HTML permissions saved a node body as Full HTML other user with permissions to edit this content type won't be allowed to edit that node's body anymore.

I guess that's the way it's going to be but that leaves us with a problem.

Now (after upgrading from D6 to D7) if I want certain role to allow to fully edit this content type I must give those users roles Full HTML permissions otherwise they can edit every field except the body field of those nodes which get greyed out.

I don't want to give that user role Full HTML (as they end up messing around with it) so I needed to find a way to convert every node body field within that content type to Filtered HTML so those users can actually fully edit every field of the content type.

I see that the table field_data_body stores the information fore every node's body. So, I needed some SQL to set every body_format from the content type my_content_type to 1 (1 is the filtered html profile, you must check your own ckEditor settings if you have more profiles)

I used this SQL to do that;

UPDATE field_data_body
SET body_format = '1'
WHERE bundle = 'my_content_type';

Hope this helps someone
Thanks for a great job