create_qr_definition

This command creates a query rewrite definition.

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

REST API syntax

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

GuardAPI syntax

create_qr_definition parameter=value

Parameters

Parameter Value type Description
dataBaseType String Required. The type of database this query rewrite definition is associated with. For valid values, call create_qr_definition from the command line with --help=true.
definitionName String Required. A unique name for this query rewrite definition condition.
description String Textual description.
isNegateQrCond Boolean Specifies if there is a NOT flag on the set of query rewrite conditions that are associated with this definition. Valid values:
  • 0 (false)
  • 1 (true)
sampleSql String  

Examples

To create a query rewrite condition named case 15, for Oracle databases:

grdapi create_qr_definition dataBaseType="ORACLE" definitionName="case 15"