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

Configure a SQL Query Scheme

You can configure a SQL Query Scheme that finds user data in the relational database that you are using as a user store.

Note: The following procedure assumes you are creating a new object. You can also copy the properties of an existing object to create an object. More information exists in Duplicate Policy Server Objects.

To configure a SQL Query Scheme

1. Click Infrastructure, Directory.
2. Click SQL Query Scheme, Create SQL Query Scheme.

   The Create SQL Query Scheme pane opens.

3. Verify that Create a new object is selected, and click OK.

   The SQL Query Scheme: Name pane opens.

   Note: Click Help for descriptions of settings and controls, including their respective requirements and limits.

4. Type a name and description in the fields on the General group box.
5. Update the contents of the query fields to correspond to your database schema.

   Note: Click Help for descriptions of settings and controls, including their respective requirements and limits.

   You must configure each of the queries 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
6. Select a query type, and click Submit.

   The query is saved. You can associate query scheme with a user directory connection

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