NAV2009R2 - Password change via User table is not working?

Slawek_Guzek
Slawek_Guzek Member Posts: 1,690
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
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Comments

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

    Does everybody really knows nothing about this NAV2009 R2 behaviour ?

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • kriki
    kriki Member, Moderator Posts: 9,121
    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 Member Posts: 1,690
    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
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories