Table Permission error on executoin of the report

POSTED BY MAXIM MICHTCHENKO  ON 25 JUN 2012 4:35 PM

I have a custom table and a SSRS report using this table on the executon of the report user is getting following error:

User 'ADMINIST' is not authorized to select a record in table 'LabelGroupDetailsTmp'. Request denied.

Cannot select a record in Product Label Group Table (LabelGroupDetailsTmp).

Access Denied: You do not have sufficient authorization to modify data in database.

i user is given the Admin rights in the system there is no error and report displays correctly.

i cannot find any way to fix this? any suggestions?

• POSTED BY RICKY SCOTT  ON 25 JUN 2012 7:16 PM SUGGESTED ANSWER

  Hi Maxim. Looks like you don't have permissions to the table in question and/or that custom table isn't part of a Privilege. Add your table to the proper privilege and your report should run.