When upgrading to Confluence 3.5 I backed up all of the calendars (via .ics files) that were found anywhere on my Confluence install. Then I uninstalled the plugin, upgraded Confuence, and installed Team Calendars.

The problem is that the only way I seem to be able to add the calendars back is as one of "my" calendars. I know that they can be embedded in any space, but this is not only annoying for me (to have all calendars that I ported over for my users sitting in my calendars) but it's going to be a political problem if people feel like they have lost control over their calendars.

Please tell me how I can reassign the owners – a SQL query, some configuration file modification, etc.

Thanks!