Update creator/owner in Secure Content <=1.9 version
- Camilo Galleguillos (Unlicensed)
- Smita Nair
Owned by Camilo Galleguillos (Unlicensed)
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>";