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
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21990835