Thanks.

The SP is simply Delete from tablename where codefield = 'C'

I've thought it was permissions all along, but I can't find any that are not set properly.

The users are all...

It could also be a way to facilitate multiple attribute values for the same product (red, blue).