Vulnerability Assessment test SQL issue_2
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.