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 ONE Support launchpad (Login required).

Search for additional results

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