Hi,
I have a very lets say interesting problem with using SSO for login.
I've made my setup if the user that logs in with SSO is new for Snow, to create that user, using the packet that come from SSO with user data and a transform map.
All works just great, but almost.
My problem is that when user is created it pass through u_user table where Snow automatically creates new column per each property in the json object with user data that comes form SSO. Most of the time it's OK, it creates 20-30 new columns in the u_user table. But there are users with huge json objects with many many properties and at some point the u_user table got 100 additional columns due to those users and I guess with the latest Snow upgrades come some limitation for the columns which makes the SSO not work when it has to create new user. Once I delete all additional columns in u_user, SSO for new users start working again.
What I want to do is to delete most of those additional columns that got created automatically based on the json properties, leave only the minimum I use for the transform map and to disable this automatic creation of columns.
How I do that?
I've searched every options in config, but doesn't find such.
Thank you in advance.
