Policy Server Guides › Policy Design Guide › User Directory and Search Dialog Reference › User Directory Dialog › User Directory Dialog—ODBC Namespace › User Directory Dialog—ODBC Namespace—Directory Setup Tab › SQL Query Scheme Group Box

Previous Topic: Directory Setup Group Box

Next Topic: User Directory Dialog—ODBC Namespace—Credentials and Connection Tab

SQL Query Scheme Group Box

The SQL Query Scheme group box is where you create or select a query scheme that the Policy Server will use for your ODBC user directory connection. A SQL Query Scheme is what the Policy Server uses to build queries for finding user data in a relational database. Without a SQL Query Scheme, the Policy Server cannot match attributes in your ODBC database with the information it needs to authenticate and authorize users.

SQL Query Scheme drop down list

Specifies an SQL query scheme from a list of all existing SQL query scheme objects.

Note: Don’t use the same data source with different SQL query schemes. Create a unique data source for each SQL Query scheme.

Configure button

Opens the SQL Query Scheme Dialog for the SQL query scheme specified in the SQL Query Scheme field.

New button

Opens the SQL Query Scheme Dialog so that you can configure a new SQL query scheme.

More information:

SQL Query Scheme Dialog

Configure SQL Query Schemes