Security Permissions for NAV Linked Objects (Views)

CraineGA

I have created a table called [Vendor Item Sales Averages] in Dynamics NAV that is a linked object to a SQL Server View with the corresponding name. The Table in NAV is displaying the data from the SQL server view as desired, when ran within the classic client.

I have created a page (list) based on the underlying table [Vendor Item Sales Averages]. However when I run the page I receive the following error message "The login failed when connecting to SQL Server ABC123"

How should permissions be assigned correctly in SQL server or otherwise?

Regards

mohana_cse06

Can you be able to open RTC in your machine from Start?

CraineGA

I get the same error message when I open the page using DynamicsNav:////runpage?page=50000. I only intend to expose the page as a web service for integration purposes, so I will not enable users to navigate to this page.

stryk

I guess you have to grant the permissions to the underlying View manually; e.g. like

GRANT SELECT ON [Vendor Item Sales Averages] TO PUBLIC

Does this work?

CraineGA

The solution in now working. Yes, granting permissions expicitly on the view within SQL server got things working. Use of linked objects obviously bypasses the standard NAV security model, lesson learned.

Thanks for the reply.