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.