Is it possible to change the creator of a page in Confluence 3.5?

[David A]

We need to do this because of security changes made by Atlassian since Confluence 3.2.

[Matthew J. Horn · Accepted solution]

Sure it's possible, especially with Bob Swift's SQL Plugin.

Here's the relevant query (this is for Confluence 4.1.2, so it might be different from 3.5 -- just check the schema):

update CONTENT set CREATOR="<new creator name>" where CONTENTID="<your content id>"

You can get details about installing, configuring, and adding permissions for this plugin here:
https://bobswift.atlassian.net/wiki/display/SQL/Confluence+SQL+Plugin

hth,

matt

[David A]

Thanks for your answer.

[Michael Benoit]

I'm using Confluence 4.3, and this solution doesn't quite work. The suggested SQL command does change the creator displayed at the top of the page, but the author of the page that comes back in an RSS feed is still the old author. The same is true for the REST API. Also, after editing the page, the author somehow gets reverted back to the original author.

If you modify the update statement a bit, the above problems go away:

update content
set creator='CONTENT_ID'
where contentid = CONTENT_ID or prevver = CONTENT_ID

[Denise Unterwurzacher [Atlassian]]

Hi all, the way this is done has changed somewhat in recent versions. Please see this page for detailed instructions: https://confluence.atlassian.com/display/CONFKB/How+to+change+the+creator+of+a+page

[Erin Brusnahan]

Hi everyone, 

We used the instructions on that page and found that Confluence must be restarted after the queries are run, otherwise the "Created By" name displayed will revert as soon as the page is edited. 

[acastner]

+1 from me. Its weird/startling to see people from so long ago...

[Doug Meisner]

Is there still an active feature request to allow this to be done in the UI? That I can vote for?

Seems ridiculous to need to do it via SQL. I saw a post requesting this in the UI back in 2013 - it really hasn't been done yet??

[Matthew J. Horn]

Do you mean within confluence (such as in a macro) or by modifying the database? If the latter, then change the value of the CREATOR field within the CONTENT table. You just need to identify the page by its CONTENTID.

[David A]

Thanks Matthew. We would preference to change it within Confluence. Is that possible?

If not, do you know of any Atlassian documentation that would give some more detail on how to build the relevant SQL query?