SQL query scheme configuration

Products

• SITEMINDER
• CA Single Sign On Secure Proxy Server (SiteMinder)
• CA Single Sign On Federation (SiteMinder)
• CA Single Sign On Agents (SiteMinder)

Issue/Introduction

The Siteminder Policy Server ships with a default SQL query template.  Does this need to be modified to support different user stores?

Environment

All supported releases

Resolution

For most ODBC user store implementations, simple substitutions can be made in the default template to support a specific environment.  Most substitutions will be for either the table name or column name.  The %s represents the inputs and will be substituted automatically at run time.  Note that whenever %s is preceded by an equals sign (=), %s should be surrounded by single quotes.  All other instances of %s should not be surrounded by quotes.