mibuso.com
Home› NAV Three Tier
Options

Security Permissions for NAV Linked Objects (Views)

CraineGACraineGA Member Posts: 28
edited 2011-06-03 in NAV Three Tier
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

Comments

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    Can you be able to open RTC in your machine from Start?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • Options
    CraineGACraineGA Member Posts: 28
    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.
  • Options
    strykstryk Member Posts: 645
    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?
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • Options
    CraineGACraineGA Member Posts: 28
    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. :)
Sign In or Register to comment.