SQL Security Model

rocatis

What's the difference between the two SQL Security Models, Standard and Extended?

Apart from the fact that Extended is slooooooooooow (sometimes several days!) and Standard is fast, the only difference seems to be that users can be synchronized independently when using the Extended model.

However, as synchronizing of a single user with Extended takes waaay longer than synchronizing all users with Standard, I really can't see the point of Extended at all.

Am I missing something?

kriki

The extended security model has also security in SQL. So the user can access those tables with other programs. With Standard, the security is only maintained in Navision and the user cannot access the DB with other programs.

nunomaia

Yes, extended security model it’s really slow. But taking day to synchronize some times is related to deadlock, I already got a few during synchronization.

If you can use standard security model, I definitely would recommend it.

kine

The difference is described in the documentation which is shipped witht he SP3.

rocatis

kine wrote:

The difference is described in the documentation which is shipped witht he SP3.

Found it - thanks! It's however worth mentioning that the documentation is only available on the WW version. I haven't found it on any of the localized installation cds yet #-o

borjagh

rocatis wrote:

kine wrote:

The difference is described in the documentation which is shipped witht he SP3.

Found it - thanks! It's however worth mentioning that the documentation is only available on the WW version. I haven't found it on any of the localized installation cds yet #-o

I 'd also like to read that document, but don't find the SP3 disk. Is that document on partnerguide? how can I find it?
Thank you.

borjagh

borjagh wrote:

rocatis wrote:

kine wrote:

The difference is described in the documentation which is shipped witht he SP3.

Found it - thanks! It's however worth mentioning that the documentation is only available on the WW version. I haven't found it on any of the localized installation cds yet #-o

I 'd also like to read that document, but don't find the SP3 disk. Is that document on partnerguide? how can I find it?
Thank you.

Found w1w1isql.pdf of Nav 5.0 CD, I think here I'll find what I need to learn about security model. Thanks