Policy Server Guides › Policy Design Guide › Policies › Policy Binding Establishment › Bind Policies to SQL Queries

Bind Policies to SQL Queries

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

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 use the Manual Entry Field to Bind Policies to a SQL Query

1. From the SiteMinder Policy dialog, click Add/Remove.

   The SiteMinder Policy Users/Groups dialog opens.

2. In the Manual Entry field, enter an SQL query.

   Specify an SQL query that finds all the users to which the policy should be bound. 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.

3. Click the Add to Current Members button.

More information:

Configure a Policy