NAV2009R2 - Password change via User table is not working?

Slawek_Guzek
Slawek_Guzek Posts: 1,692
edited 2013-09-20 in NAV/Navision Classic Client
Hi All,

It seems that changing Password field on User table does not change users's password on the SQL server. Even if Tools->Security->Synchronize All is executed aftewards the password on the SQL box does not get updated.

There is also no other way around integration - password change function (Tools->Security->Password..) for database users does nothing with Password fied in User table. Password - OnValidate trigger is not even fired..

NAV dababase is configured to use Standard security model.

Is this some new feature in NAV2009 R2 client, or a bug in the first release of NAV 2009 R2 binaries (I am using build no 32012), possibly addressed in some hotfix ?

Thanks for any clues.
Slawek
Slawek Guzek - www.yitron.co.uk
Business Central, MS SQL Server, Wherescape RED;

Comments

  • Slawek_Guzek
    Slawek_Guzek Posts: 1,692
    Two days and nothing posted ?

    Does everybody really knows nothing about this NAV2009 R2 behaviour ?

    Slawek
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;
  • kriki
    kriki Posts: 9,135
    That fields is only useful if you are using the native DB. If you are using a SQL database, that field is always blank (except if you fill it up manually, but it does not have any function). If you want to change the password, you need to do that directly in SQL Server.
    BTW: why are you using database logins and not Windows logins? they are easier to use and also more secure and the user can change it when he wants by changing his Windows-password.
    The only reason for having a databaselogin is for people outside of your domain like the people of your NAV-partner in case they open NAV directly on their PC's. (actually it is better doing a remote desktop session on a terminal server and working from there).
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Slawek_Guzek
    Slawek_Guzek Posts: 1,692
    Hi,

    Thanks.. We are migrating customer from old Native to 2009 R2 on SQL.. He was using database authentication due to security reasons. He has some password complexity enforcement rules plus some other stuff coded in Password - OnValidate trigger. This is no longer working as the trigger isn't fired when user changes his password.

    I was pretty sure that Password field in User table used to be working on SQL in some previous NAV versions.

    Slawek
    Slawek Guzek - www.yitron.co.uk
    Business Central, MS SQL Server, Wherescape RED;

Categories