I created a stored procedure that has
INSERT statements in it that I use for an SSRS report.
I typically only use an account that is a member of
db_datareader for SSRS reports, however this stored procedure will not execute with an account that only has those rights. The following error is reported when attempting to execute the stored procedure:
Cannot find the object "table_name" because it does not exist or you do not have permissions.
Do I need to use an account who has
db_datawriter members to execute this SP or is there a way for me to have my
db_datareader account execute it?