IBM Support

Special Characters in Guardium Query Conditions

Question & Answer


Question

I have previously been able to create use special characters in query conditions on the Guardium GUI but I am no longer able to do so as I receive this error message: ‘Invalid Query. Input fields cannot have special characters’ What special characters are allowed in Guardium query builder conditions?

Answer

In Version 9 GPU p700, Guardium does not allow the user inputs in the conditions for these special characters:

" [ ] ( ) $ | & ; ' \ !

These are double quote, parentheses, dollar sign, vertical bar, ampersand, semi colon, single quote, backslash and exclamation mark.

When any of these characters are used in a query condition, this error message will be shown and the condition cannot be saved:

The reason for this change is to:

· Increase security by preventing SQL injection


· Make sure that the saved query can run as expected

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21990835

Page Feedback