Nav permissions on SQL

eugenious

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.

TrippyZ

Are there any entries in those tables?

ta5

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

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

Are you sure you synchronized?
You might want to upgrade (runtime upgrade) to SP3 or 5.0 and use the standard security model.

eugenious

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

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.