Creating a SQL Policy

the execution of queries can be prevented or allowed by sql policies navigate to policy control > session policy click the + add button next to the policy key title select the policy key type in the opened pop up s elect white or black key enter the query (or regex) to prevent or allow select the policy type and element type click save at least one policy key must be assigned to the related realm for sql proxies if only black key policies are defined in a realm, all remaining queries will be white key if only white key polices are defined in a realm, all remaining queries will be black key if only the “ ” regex is defined as white key, all queries are allowed to run if only the “ ” regex is defined as a black key, all queries will be blocked the conditions listed in the table below are restricted by default to prevent the inference of masked data if required, these conditions should be defined as white keys and assigned to the relevant policy groups type condition / function name condition c$where$ condition c$when$ condition c$then$ condition c$order by$ condition c$group by$ condition c$partition$ condition c$exists$ condition c$is null$ condition c$in$ condition c$on$ condition c$between$ condition c$for$ condition c$else$ condition c$not$ condition c$case$ function c$switch$ function c$cast$ function c$extract$ function c$parenthesis$ function c$insert$ function c$update$ function c$pivot$ function c$timezone$ function c$equalsto$