What is the data field size limit for ODBC policy stores in Siteminder?

Products

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

Issue/Introduction

What is the maximum size of a single value that can be saved in an ODBC policy store?

Resolution

The out of the box .sql files used to configure an ODBC policy store use 4000 character limits.  This can be adjusted in the DB after creation, or these values can be adjusted in the .sql files prior to configuring the database.  Be aware that each database type may have it's own limits.