mibuso.com

Microsoft Business Solutions online community
It is currently Tue May 21, 2013 11:39 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: [Solved] Security issue after change of table
PostPosted: Tue Jan 20, 2009 2:03 pm 
Offline

Joined: Thu Jun 09, 2005 9:29 pm
Posts: 232
Location: Herselt (Behind the world)
Country: Belgium (be)
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?


Top
 Profile E-mail WWW  
 
 Post subject: Re: Security issue after change of table
PostPosted: Tue Jan 20, 2009 4:31 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Thu Jul 31, 2003 12:00 pm
Posts: 639
Location: Nürnberg
Country: Germany (de)
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

_________________
Jörg A. Stryk (MVP - Dynamics NAV)
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool


Top
 Profile E-mail WWW  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: