Problem
There might be scenarios where the owner of a secure content block(s) has to be modified. This page explains how a system administrator can perform the same.
Solution
There is no UI exposed to do this so it must be done in the database. Ensure to test this in a development instance before attempting in production.
- Shutdown your Confluence instance and take a backup of the database.
- Use SQL similar to the following to update your creator, which is also the owner of the block, in Secure Content for Confluence versions < 2.0:
SELECT creator FROM AO_429DB9_SECURE_CONTENT WHERE `key`="<key of the secure content block>"; UPDATE AO_429DB9_SECURE_CONTENT SET creator="<userid>" where `key`="<key of the secure content block>";