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

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