Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
  • 1.  Native Encryption - rights management

    Posted Wed March 31, 2021 12:25 PM

    Hi,

    having a un-encrypted database with a separated SECADM user.
    If I want to set the ENCRLIB DB CFG parameter I run into problems.

    Issuing

    db2 "update db cfg for test using encrlib /home/db2inst2/sqllib/lib64/libdb2encr.so"

    • SYSADMIN & DBADMIN: will get a SQL6112N RC 15
    • SECADM will get SQL1092N

    So how should it be done with separated SECADM roles?

     

    best regards

    Michael Tiefenbacher


    #Db2
    #Db2EarlyAccessProgram(EAP)Forum


  • 2.  RE: Native Encryption - rights management
    Best Answer

    Posted Wed March 31, 2021 12:25 PM

    Hi Michael,

     

    This is a bug.  SECADM should be necessary and sufficient to update ENCRLIB and ENCROPTS.  We will make sure this gets fixed.

     

    Greg Stager