Security issue after change of table

vanrofi

Hi all,


We run Nav5.0 sp 1 on SQL with windows users.
As soon as we change a table (adding field,...) we see that users lose the access to the table. I need to resync the user's security whick of course forces the users to logoff and on. As we have 15 companies in 4 database with 100+ users, this takes a lot of time.
We even have the feeling this has become worde after installing SP 1, but that can be coïncidence.

Is there a way that this can be bypassed, or is it possible that security setting on that 1 table is resynced in sql, without any disturbance for the users?

stryk

Hi!

Well, actually this depend on the "Security Model" you have set for the NAV database; the described issue is normal behaviour with "Enhanced" SM which you probably run.
I recommend to set it to "Standard" as in this case it won't be necessary to synchronize after table changes (and "synchronization" is perfromed much faster anyway!).
Please refer to the "Installation & System Management (SQL)" PDF (chapter 4) to compare both models, or browse this forum for more info.
Have in mind that you'll need to have the "xp_ndo_enumusersids" Extended Stored Procedure installed for "Standard" SM (currently you probably have "xp_ndo_enumusergroups").

Kind regards,
Jörg