INSERT permission was denied

The INSERT permission was denied on the object 'X', database 'Y', schema 'Y'.

Can be caused by overzealous addition of permissions. Make sure the Role Members 'db_denydatawriter' and 'deny_datareader' are unchecked.