Skip to main content What is Dynamics 365? Guided tours Customer stories Try our products Build your own agents CRM ERP Sales Service Sales Customer Insights Customer Service Contact Center Field Service Supply Chain Management Commerce Finance Project Operations Human Resources Business Central Pricing Business application topics Training & certifications Migrate to the cloud Documentation Events Dynamics 365 Blog Product updates Onboarding and implementation Community Find a partner Software Development Companies Partner resources Microsoft Marketplace Product documentation Technical support On-premises product support Contact us Try for free Sign in
  • 1 min read

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.

Actual:
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.

Get started with Dynamics 365

Drive more efficiency, reduce costs, and create a hyperconnected business that links people, data, and processes across your organization—enabling every team to quickly adapt and innovate.