Nav permissions on SQL

eugenious
eugenious Member Posts: 7
edited 2007-04-02 in NAV/Navision Classic Client
Hello everybody.

I have transfered Nav 4.0 SP2 from native database to SQL database, and now I have an interesting bug.

Working in Navision, people started to receive errors like "SQL.... you do not have permissions for "Item Analysis View Entry table",
or for "Warehause" something....
Yep, they really do not have persmissions for that - we have no such granules in license. But why Navision on SQL started trying to use those granules???

Now problem is temporary solved - by setting everybody as SUPER users... but this is really not good :)

Has anyone such problems before? Any advice?

Thanks.

Comments

  • TrippyZ
    TrippyZ Member Posts: 87
    Are there any entries in those tables?
    Professional Navision Developer
  • ta5
    ta5 Member Posts: 1,164
    We once had a similar problem with a customer.
    The customer had worked with a Cronus or a NSC License and produced data in other than desired tables.
    If you use the debugger you should find out that it breaks on a find statement. As far as I remember Native Version allows finds on non licensed tables, SQL Version does not.

    To solve the problem you have to manually clean out some data or change some c/al code.

    Hope this helps
    Thomas
  • eugenious
    eugenious Member Posts: 7
    No, there are not. This is what I have first cheked.

    Also, there is some intresting thing - there were error about "You do not have permissions for Transfer Line table" for people, who are working with transfers and sure they have permission group with Transfer Line RMD-Yes.
  • Waldo
    Waldo Member Posts: 3,412
    Are you sure you synchronized?
    You might want to upgrade (runtime upgrade) to SP3 or 5.0 and use the standard security model.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • eugenious
    eugenious Member Posts: 7
    Yes, I am sinhronized
    and yes - I am usind SP3 client, and server.

    and I am using standart sequrity groups with small modifications for new objects.
  • kine
    kine Member Posts: 12,562
    eugenious wrote:
    Yes, I am sinhronized
    and yes - I am usind SP3 client, and server.

    and I am using standart sequrity groups with small modifications for new objects.

    What Waldo means are not the groups (roles) but the Security Model in "File-Database-Alter-Advanced-Security-Model = Standard". It seems that you have this set to =Enhanced. How to switch the model is described in document "Security Synchronization in Navision 4.0 SP3.doc" in DOC folder of NAV 4.00SP3 install cd.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories