Creating a SQL Policy
1 min
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
- Select the 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.
SQL Policy Key Definition / Key Type selection is White Key