Policy Server Guides › Policy Server Configuration Guide › User Directories › SQL Query Schemes › Add SQL Query Schemes to ODBC User Directory Connections

Add SQL Query Schemes to ODBC User Directory Connections

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

To select an SQL Query Scheme

1. Open the User Directory pane for an existing user directory connection object.
2. Select the SQL query scheme from the SQL Query Scheme list, and click Submit.

   The SQL query scheme is saved to the directory connection.

3. Restart the Policy Server using the Policy Server Management Console.

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'.