User Role Inconsistency

cincai

Hi all,

I am having a problem while setting the permission. The scenario is this.

I try to setup the user role by only allowing a user to access only to the GL module. However, this setting is only work on 1 PC and doesn't work with the other PC. Both as DB owner and DB admin.

NAV version 4.0 (but using NAV 4.01 Fin.exe to run)
MS SQL 2000 (with xp_ndo.dll version 4.0.1)
Window Authentication

Please advise should i miss out anything?


Thanks

ara3n

Any time you make a change to security, you need to synchronize, and only assign the users public role.

The other user on the pc has to log out and in after the change to see the difference.

Need more detail example.

garak

Please set the sql role "DB owner" only for the person how modify / change objects. For all other users -> Role "public".

If you has changed some tables (not the C/AL code, but keys or fields) or created new tables, u must synch. the permission (Tools --> Securit< --> Synchr.)

Since 4.03 u can use the "Enhanced" (like under 4.00 - 4.02) or the "Standard" security model. With option "Standard" you doesn't need the synchronisation.

regards