Policy Server Guides › Policy Server Configuration Guide › Policies › Bind Policies to SQL Queries

Bind Policies to SQL Queries

CA SiteMinder® allows you to use the Manual Entry field to specify a SQL query to bind policies to users.

To use the Manual Entry Field to Bind Policies to a SQL Query

1. Navigate to Policy, Users.
2. Locate the group box with the user directory that you want to search, and then click Add Entry.

   The User Directory Search Expression Editor opens.

3. Click the Where to Search drop-down list, and then select Search Users.
4. In the Manual Entry field, specify a user DN.

   For example: uid=JSmith, ou=people, o=myorg.org

   Note: This user DN must match exactly the user’s distinguished name. This feature will not match a subset of information contained in the user’s DN.

5. Click OK.

   The User Directory Search Expression Editor closes and the user DN you entered appears in the group box of the directory.

6. Click Submit to save your changes.

   For example, to bind a policy to all people whose account balance is greater than $1000, a query might look like this:

   SELECT name FROM customers WHERE balance, 1000

   The contents of the SQL query depend on your database schema.