web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

GP 2010 - Table Security Violation error when printing in Report Writer

(0) ShareShare
ReportReport
Posted on by 1,755

In GP 2010, I granted a user access to Report Writer and she can successfully edit reports and change restrictions in Report Writer. I have granted her access to each Custom Report under the Security Tasks window. However, when she tries to print a report from Report Writer she gets a "Table Security Violation" error. 

The strange thing is this user is able to print this customized report directly through GP w/ no errors by going to Reports > Customized.

This report uses the Year-to-Date Transaction Open and Account Master table. This user has access to the Account Maintenance window and the Detail Inquiry window so I am assuming the user has access to both of these tables.

What additional permissions do I need to grant this user so she can print modified reports directly from report writer?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Greg,

    That type of message is usually coming from the SQL server side... When the user is in RW, she does not use the GP security in Edit Mode and therefore may need different local security on the server side to test the reports. Bear in mind that in RW Edit mode,you wont necessarly print the data you're looking for, since most reports are parameter driven and you can't do that in RW. You may only be ableto  test the layout of the report, but  you still need to have access to the tables, because RW validates the data source. Some reports will print the last data entry from the table that is related, some will just be empty.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans