SQL Server 2008 - Permission Issue
Posted on 2012-09-11
Good evening experts:
I'm having some issues with what appears to be permission issues while attempting to insert records from a .NET application. The strange this with this issue is that it is limited to two specific tables, and only occurs when inserting records.
Using the same user credentials, I have no issue with inserting data into many of the other tables utilized in the .net application.
When attempting to execute the INSERT stored procedure, I receive the following exception:
Cannot find the object 'tblVendor' because it does not exist or you do not have permissions.
If I execute a SELECT query against tblVendor with the same credentials, I am able to retrieve all the records from this table.
This situation applies to two tables in the database, and any help would be much appreciated.
Using SQL SERVER 2008 R2