--SQL Server 2008 R2-- I have created a Login in a DB, that login has db_datareader and db_datwriter and it has Execute on all the SP's in the DB.
When I execute that SP, I get a rights error on the table referenced by the SP. But when I add the table as a securable for that user with the appropriate Grants, then it works.
I was under the impression that is you set Exec rights on the SP's then you don't have to set any rights on the tables that SP touches, is this not correct? And therefore i will have to set grants for ALL the tables too?