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.

MSSQL User Permissions

This entry was posted in Programming and tagged . Bookmark the permalink.

2 Responses to The INSERT permission was denied on the object ‘X’, database ‘Y’, schema ‘Y’.

  1. K says:

    Thank you!!

  2. jozer says:

    very nice. helped a lot

Leave a Reply

Your email address will not be published. Required fields are marked *