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:
| Code Block |
|---|
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>"; |