It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage
Highlighted

Any way to change Creator name on ALL Confluence pages?

We have a user that is no longer here at our company. But majority of the pages are assigned to this user. And our upper management would want it changed over to someone else. There must be a way to do this.....? Someone please help.

 

Or provide a working SQL query code.

1 comment

@atlassian_dragonYes I tried following this exact guide.

 

I tried to run:

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>');

 

But it gives me an error: 

Msg 208, Level 16, State 1, Line 1
Invalid object name 'content'.

@atlassian_dragonAny reply on this? We can't figure out how to change all the old user to the new user in one go.

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence

How To: get the most out of the new Confluence navigation and Home

Hi Community, Elaine again from Confluence Cloud Product Management. Most of you have used the new Confluence navigation and Home for some time by now. Not sure what changed or just want to lear...

314 views 2 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you