How to change the creator of a page in Confluence 5.2 or above

For Confluence 5.2 and above

To change the creator of a specific page

Run this SQL query against your database, replacing these values:

<lowerusername> with the username of the new creator in lower case
‘the title of the page’ with the page title (case sensitive)
<thespacekey> with the spacekey in uppercase

update content set creator = (select user_key from user_mapping where lower_username = '<lowerusername>')
 where contentid in (select c2.contentid from content c2 where c2.title = 'the title of the page'
            and spaceid = (select spaceid from spaces where spacekey = '<thespacekey>'))
  or prevver in (select c2.contentid from content c2 where c2.title = 'the title of the page'
            and spaceid = (select spaceid from spaces where spacekey = '<thespacekey>'));

To replace all content created by a single user

Run this SQL query against your database, replacing these values:

<newlowerusername> with the username of the new creator in lower case
<oldlowerusername> with the username of the old creator in lower case

update content set creator = (select user_key from user_mapping where lower_username = '<newlowerusername>')
 where creator = (select user_key from user_mapping where lower_username = '<oldlowerusername>');