SAP Knowledge Base Article - Preview

3372056 - Verification on the fourth parameter when using the 'set' option of sp_passwordpolicy - SAP ASE


  • The fourth parameter of sp_passwordpolicy when using 'set' option is for 'keypair regeneration period' ONLY.   
    1> sp_passwordpolicy "set", "keypair regeneration period", "2H", "Aug 30 2023 12:01 AM"
    2> go
    Msg 19633, Level 16, State 1:
    Server 'test', Procedure 'sp_passwordpolicy', Line 688:
    Network password encryption keypair will be regenerated at Aug 30 2023 12:01AM.
    (return status = 0)
  • Executing sp_passwordpolicy with fourth parameter on 'set' at options other than 'keypair regeneration period' run fine with no error/warning message.
    1> sp_passwordpolicy 'set', 'password exp warn interval', '0', sa
    2> go
    (return status = 0)
    1> sp_passwordpolicy 'set', 'systemwide password expiration', '0', sa
    2> go
    (return status = 0)
  • The sp_passwordpolicy is for global settings, it is not for individual settings. The above commands for 'sa' are incorrect.
    No message, no warning printed giving the impression that the above "worked" for user sa.



SAP Adaptive Server Enterprise


SAP Adaptive Server Enterprise 16.0


CR 828344, 828344, CR#828344, alter login, sp_passwordpolicy, sa, keypair regeneration period, password, password expiration, ASE , 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.