SAP Knowledge Base Article - Preview

2388670 - create login does not pass the login name to sp_extrapwdchecks - SAP ASE

Symptom

  • Create login does not pass the login name to sp_extrapwdchecks
  • login name and new password are stored in sp_extrapwdchecks
  • To be able to add an extra password check against the login name
  • SAP recommended to use create login and alter login, but return Msg 10316, 11188 and Msg 11165
  • 1> create login user1 with password sybase
    2> go
    Invoking sp_extrapwdchecks now...
    (return status = 0)
    Msg 11165, Level 16, State 3:
    Line 1:
    A user, group, login or login profile with the name 'user1' already exists in this server.
  • 1> alter login user1 with password null modify password sybase
    2> go
    Msg 10316, Level 14, State 2:
    Line 1:
    New password supplied is the same as the previous password.  Please supply a different new password.
  • Msg 11188, Level 16, State 1:
    Line 1:
    Cannot alter login.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Msg 11165, Level 16, State 3, Msg 10316, Level 14, State 2, Msg 11188, Level 16, State 1, login, password, login name, sp_extrapwdchecks, alter login, create login, CR763150, CR#763150, 763150 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.