Thanks phil for the last answer.
What I need is to retain the identity field as this number needs to autogenerated as to change the code would be too much work in a complex system.
So I am still back to the need to turn on the identity insert option globally so that any user other than a dbo can do insert a value.
Karyn