thanks for your help anyway

after granting access for the sp to the webuser and doing all the above I still get the same error when trying to execute the sp via webuser:

Server: Msg 8104,...

can you give me an example how to create and execute that sp pls?

also the webuser is connecting from a remote computer so with RPC off (I don't know if...

what do you mean? I've opened MS query analyzer and run GRANT INSERT ON MYTABLE TO webuser

I use this login (webuser) for executing queries from a php website and I...

I granted access to the sql user on that table. Then I connected to the sql with that user and tried to SET identity_insert on that table to ON but...

once I grant INSERT rights to the user he can permanently use the IDENTITY_INSERT command? or I have to do this everytime? Is there any way to give rights for...

Can I give (and if yes how?) only INSERT pesmissions to a user?

I mean I only want the user to be able to INSERT without being a sysadmin or db_owner

Thanks...