How to delete photos for other users?

[Karina Clemente]

How can the System Administrator change the profile picture for the users? Is there a way to do mass upload?

[Bruna Griebeler · Accepted solution]

Hello Karina

Since Confluence is a collaborative tool just the users are able to change their own pictures.
What you as admin can do is reset a user password, access Confluence using the user credentials and then change the picture.

Another possibility is to change the default profile picture in the database, but in that case all the users will use the same picture:

Example:
UPDATE OS_PROPERTYENTRY SET string_val='/images/pathToTheNewImage/image.png' WHERE entity_key='confluence.user.profile.picture';

Hope it helps!

[MatthewC]

if you reset the user's password, they won't be able to get back in, you don't (or shouldn't) know their password. Also, if you are backing onto an LDAP/Active Directory you might not be able to change the password.

[Karina Clemente]

Thanks for your answer! I logged in as the user and changed the picture. There was no other way...

[MatthewC]

1. You can use the Confluence SU plugin to do it manually by switching into a users account & uploading https://marketplace.atlassian.com/plugins/com.javahollic.confluence.confluencesu
2. you could use a gravatar profile picture which is tied to a users email address https://marketplace.atlassian.com/plugins/net.vicox.confluence.plugins.gravatar
3. or you could do a write a SQL script to set user profile pictures & then copy them to Confluence home directory. There is a related question here about how to read the data https://answers.atlassian.com/questions/15018/retrieve-profile-pictures-using-sql