Additional Query Settings

Set additional query settings to support the SQL queries.

Important
SQL entries can't end with a semicolon (;). Ending an SQL entry with a semicolon (;) can cause a general error message to display.

1. (Optional) Select the Use executeQuery checkbox to return a single ResultSet object when it queries the JDBC database.

2. (Optional) Enable Direct Permission and add the Direct Permission SQL query. For more information on supported direct permissions, refer to Direct Permissions.

   The Direct Permission Execute Query is used to pull the direct permission data from a permission table. The permission table must contain at least an Identity attribute column. Identity Security Cloud pulls permission data using an SQL query to refer to the Identity attribute during aggregation process.

   The SQL query must be written in such a way that ResultSet data contains Target as a first column and Permission as a second column. Optionally, you can add a third column and set it as Annotation.

   For example, if you reference a permission table named Permission and you use $(identity) as the Identity attribute, you could use the following SQL query:

   SELECT column4 AS TARGET,column5 AS PERMISSION FROM Permission p WHERE CONCAT(TRIM(CONCAT(p.column1,'\ ')), TRIM(p.column2)) = '$(identity)'

   Select the Use Stored Procedure for Single Account SQL Query checkbox to execute a stored procedure on the database.

3. Select Save.