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

Bind Policies to SQL Queries

You can specify a SQL query to bind policies to users.

Follow these steps:

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: The user DN must match exactly the distinguished name of the user. This feature does not match a subset of information that is contained in the user 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 could look like the following:

   SELECT name FROM customers WHERE balance, 1000

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