IBM Security Guardium Ideas Portal


This portal will be removed

In IBM’s effort to continue to streamline and simplify navigation for our customers, this Ideas portal will be shut down on February 28, 2023. We would ask that you use the main IBM Ideas portal at https://ideas.ibm.com/ or the IBM Security-specific portal at https://ibmsecurity.ideas.ibm.com/ to review, vote for existing ideas, or add new ideas.

Vulnerability Assessment test SQL issue.

Hi, I created a case, TS007345754 to describe the issue on vulnerability assessment test "Default Accounts Password Changed" for Oracle. The test SQLs cause hard parse on the DB. It needs to be optimized but R&D requests RFE to fix the issue. The issue is not about any report or result, the issue is about test SQLs designs. Guardium Central manager runs the SQLs without any bind variables and send the same SQLs to the DB again and again , instead of sending SQLs once, and change the variables to get the same result. In our case the SQL in the below is run 574 times in my test environment, to optimize it Guardium should send the SQL once and give the other values as variables. You can find all the SQL commands that CM runs on my test DB in the attachment, hardparse.xslx. SELECT usr.name FROM sys.user$ usr, dba_users acc WHERE usr.name = acc.username AND usr.name= '#INTERNAL' AND usr.password = '87DADF******B777' AND acc.account_status in ('OPEN','EXPIRED')","1","0","","","" You can also use the document below to understand the difference between hard parse and soft parse and optimize the Guardium predefined VA SQLs to avoid hard parsing in the DBs. In our cases , DBAs complain about the "Default Accounts Password Changed" test but I belive there are more test SQLs that need to be optimized. https://ittutorial.org/hard-parse-vs-soft-parse-and-bind-variable-in-oracle-database/amp/ Best Regards, Adem
  • Guest
  • Dec 2 2021
  • Future consideration
  • Guest commented
    28 Mar, 2022 02:52pm

    We are considering adding this support in a future release of Guardium Vulnerability Assessment. We will keep you posted.


    Thank you,

    Guardium Product Management Team

  • Admin
    RAJESH VENKATASUBBU commented
    8 Dec, 2021 02:49am

    Hello, thank you for submitting your request for enhancement for Guardium Data Protection. We are reviewing this request, we will get back to you with our findings.

    Thanks,

    Data Security Product Management

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.