Group Query Settings

Configure the SQL queries Identity Security Cloud uses to retrieve group data from your JDBC server.

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. Enter a SQL query to load groups into the Group SQL Query field. Groups are used for entitlements.

    Check the Use Stored Procedure for Group SQL Query box to execute a stored procedure on the database.

  2. Enter a SQL query to load a single group into the Single Group SQL Query field.

    Check the Use Stored Procedure for Single Group SQL Query box to execute a stored procedure on the database.

  3. Select Save.