Deleting Unused Roles

kleland · 2006-11-09

Hello. We've been talking about deleting all the "standard" Navision user roles, since we don't use them anyway. (Except for "all" of course.) Is there any down side that you know of to getting rid of those roles? I would think it would really speed up the synchronization process…

Thanks for you help,

Kevin

Waldo · 2006-11-09

It will not speed up the synchronization process.

The synch process since 4.00 is completely redesigned, creating a role per user and attaching that role to a table (or something like that). this means, when synching all users, it has to synchronise quite many records (number_of_users * number_of_tables).

In 4.00 SP3, this has been "solved" ... there is a new security model named "standard".

All you should do is do a runtime upgrade to 4.00SP3, and change from "enhanced" security model to "standard" security model (in the "alter database"-form).

Waldo · 2006-11-09

Oh yes ... about the roles.

I would not delete them. They don't do anything on performance. They are just there for the one time you would need them some day in the future.

kleland · 2006-11-09

Thank you both very much for all of your help.

We will just leave them alone as you suggest.

Thanks again.

ara3n · 2006-11-10

If you really want to speed up sync process, upgrade the clients to sp3 and change the security model to standard, this will move the security model back the way it was in 3.7. Synchronization will take a few seconds.

Waldo · 2006-11-10

And then there are people saying that Microsoft doesn't listen to the community

Deleting Unused Roles

Comments

Categories