Policy Server Guides › Policy Design Guide › User Directories › Configure SQL Query Schemes › Configure a New SQL Query Scheme

Configure a New SQL Query Scheme

You can configure a new SQL Query Scheme by using the SQL Query Scheme Dialog.

Note: When you create or modify a Policy Server object in the Policy Server User Interface, use ASCII characters. Object creation or modification with non-ASCII characters is not supported.

To configure a New SQL Query Scheme

1. Open the SQL Query Scheme Dialog.
2. Update the contents of the query fields to correspond to your database schema.

   Each of these queries listed in the table above must be configured to work with your relational database. You must replace the following database table and column names with the table and column names from your relational database:

   • Name

     When you configure the Policy Server to use a user store residing in a relational database, the Name parameter for a user must be unique so that SiteMinder can correctly identify the user. Thus, two users cannot have the same user name.

   • SmUser—table
   • SmGroup—table
   • Password
   • SmUserGroup—table
   • Id
   • UserID
   • FirstName
   • LastName
   • TelephoneNumber
   • EmailAddress
   • Mileage
   • PIN
   • GroupID
   • Disabled

   Note: Once you configure a SQL query scheme you can associate it with a user directory connection.

3. Select a query type:

   Use Literal Query

   This is the default query type.

   Use Bind Query

   Replace each instance of '%s' with a question mark (?) to use bind-based parameters in the query. Any instance not changed should remain as '%s'.

   Restrictions:

   • Advanced Password Services (APS) does not support bind-based parameters.
   • A query uses bind-based parameters if it contains a question mark (?) and literal parameters if it contains '%s'.
   • A query cannot contain '%s' and question marks (?) together.

4. Click OK.
5. If you specify a new SQL query scheme for a user directory connection, restart the Policy Server using the Policy Server Management Console.

More information:

SQL Query Scheme Dialog

Configure ODBC Directory Connections