Policy Server Guides › Policy Design Guide › User Directories › Configure SQL Query Schemes › Select an SQL Query Scheme for an ODBC User Directory Connection

Select an SQL Query Scheme for an ODBC User Directory Connection

You can select an SQL Query Scheme using the User Directory Dialog.

To select an SQL Query Scheme

1. Open the User Directory Dialog for an existing user directory connection object.
2. Select the Directory Setup tab.
3. From the SQL Query Scheme drop-down list, select the SQL query scheme you want to associate with the user directory connection.
4. Click OK to save your selections and close the User Directory Dialog.
5. Restart the Policy Server using the Policy Server Management Console.

   For information on the Console, see the SiteMinder Policy Server Management Guide.

Note: If you are using MS SQL Server, and your queries are returning names that include the apostrophe character (for example, O’Neil), you must replace any instance of ‘%s’ in the query strings to ‘’%s’’. To avoid this problem, base your queries on user IDs that do not include apostrophes, or modify the query strings that include ‘%s’.

More information:

Navigate to the User Directory Dialog