update_qr_condition

This command creates a query rewrite condition.

This API is available in Guardium V10.1.4 and later.

REST API syntax

This API is available as a REST service with the PUT method. Call this API as follows: 
PUT https://[Guardium hostname or IP address]:8443/restAPI/qr_condition

GuardAPI syntax

update_qr_condition parameter=value

Parameters

Parameter Value type Description
conditionName String Required. The unique name of this query rewrite condition.
definitionName String Required. The query rewrite definition that is associated with this condition.
depth Integer The depth of the parsed SQL that this condition applies to (1 and higher). The value 1 means that the query rewrite condition applies to any matching SQL at any depth. Default = 1
isForAllRuleObjects Boolean Indicates that the specified condition applies to all objects for the fired rule. Valid values:
  • 0 (false)
  • 1 (true)
Default = 0
isForAllRuleVerbs Boolean Whether or not the specified condition applies to all verbs for the fired rule. Valid values:
  • 0 (false)
  • 1 (true)
Default = 0
isObjectRegex Boolean Whether or not the specified object is specified by using a regular expression. Valid values:
  • 0 (false)
  • 1 (true)
Default = 0
isVerbRegex Boolean Whether or not the specified verb is specified by using a regular expression. Valid values:
  • 0 (false)
  • 1 (true)
Default = 0
newName String The new name for the query rewrite condition.
object String An object (table or view). The default * means all objects. This can also be specified as a regular expression, in which case set the isVerbRegex to True.
order Integer Specifies the order in which to assemble multiple related query rewrite conditions for complex SQL. Default = 1.
verb String A verb (select, insert, update, delete). The default * means all verbs.

Examples

grdapi update_qr_condition definitionName="case 16" conditionName="qr cond15_3" newName="qr cond16_3" verb=select object=* dept=2 order=3