We have a web application that uses stored procedures in a sql 2005 database. There is a group on our database that has execute permissions to the stored procedures. Everything works fine but unless we grant the group select permissions on one table, tableA, we receive an error in our application. Even though there is a stored procedure to select from tableA and we checked that the goup has permissions to the stored procedure. The other tables work fine without explicitly granting the group select on the tables.
We have noticed in our development environment this does not happen. TableA does not require select permissions in development and everything in the app runs fine. What setting in SQL could be causing this? We looked at permissions on the db and did not see any difference.