Changes in the database tables for OAuth persistent grants and extended attributes - PingFederate

Changes in the database tables for OAuth persistent grants and extended attributes - PingFederate - 10.1

PingFederate Server

bundle

pingfederate-101

ft:publication_title

PingFederate Server

Product_Version_ce

PingFederate 10.1

category

Product

pf-101

pingfederate

ContentType_ce

For columns in the pingfederate_access_grant and pingfederate_access_grant_attr tables using the VARCHAR data type, PingFederate 7.3 updated the data type to NVARCHAR for performance reasons.

This information is applicable only to customers who have deployed Microsoft SQL Server to host their OAuth grant datastore.

The table-setup scripts (targeted for Microsoft SQL Server) in the <pf_install>/pingfederate/server/default/conf/access-grant/sql-scripts directory have been updated. If you are upgrading from PingFederate 7.2 R2 or an earlier version with OAuth use cases, consider updating the data type in both tables accordingly to avoid potential issues caused by incompatible data types between these two tables. Consult with your database administrator, as needed.