IBM Support

Can encryption be turned on in the SYSIBM.USERNAMES table for the password column?

Question & Answer


Question

I understand that DB2® has the capability to encrypt table columns. Can this encryption be turned on in the SYSIBM.USERNAMES table for the password column? Because this table is a catalog table, will the encryption interfere with the operation of the database?

Answer

DB2's built-in column encryption function cannot be used for the SYSIBM.USERNAMES password column. The DB2-supplied SYSPROC.DSNLEUSR stored procedure provides the capability to store the authorization ID and password in encrypted form in the SYSIBM.USERNAMES table. For more information about the SYSPROC.DSNLEUSR stored procedure, see http://www.ibm.com/support/knowledgecenter/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sp_admindsnleusr.html

Related Information

SYSIBM.USERNAMES table

[{"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"10.0;11.0;12.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21170167

Page Feedback