When creating a view receiving an error indicating not authorized to access table.

Example of issue:

1. Create a view that joins 2 related tables.  I used CustTable as root table, and custTrans as related table.
2. Do not add any fields to the view.
3. Right click on the view and select open.

You receive an error message that says
“You are not authorized to access table ‘custTable’ (custTable). Contact your system administrator.”

The message is misleading as the actual issue is no fields have been added to the view from the CustTable or CustTrans tables.  To address the error message add field/s to the view.

We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!