SAP Knowledge Base Article - Preview

3292545 - Selecting the password from the SYS.SYSUSER or SYS.SYSEXTERNLOGIN system views no longer displays the full encrypted password hash representation - SAP IQ


  • Selecting user login information from the SYS.SYSUSER or SYS.SYSEXTERLOGIN system views, for user IDs that have passwords that are not NULL, the representation of the password is now returned as a 3 byte length character string of '***' and displayed as: 0x2a2a2a.
    • This display change is now seen as of SAP IQ version 16.1 onwards.
    • For systems upgraded from releases prior to IQ 16.1, the display change is only seen once an ALTER DATABASE UPGRADE is run.
  • This can present a problem for those who have operational requirements, which must:
    • First extract user information from a development or test system
    • Prior to refreshing these databases with a restore from a production backup.
    • Post restoring the original development/test login credentials could then be reinstated.
  • The same problem can present itself for when trying to copy a Login from one SAP IQ or SAP HDLRE instance to another.



SAP IQ version 16.1 (all versions)


SAP IQ 16.1


sybase, 161, fail, user_id, login, login_id, regression, restore, refresh, logon, security, permission, hash, hexadecimal, hex, Hana, DL, Datalake, 'data lake', HDLRE, iqunload, utility, instance, 'external login', proxy, remoteserver , KBA , BC-SYB-IQ , Sybase IQ , How To

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.