How to disable avatar for inactive users?

Manuel February 22, 2018

Due EU Laws (EU General Data Protection Regulation / EU-DSVO)  we need to change the information related to inactive / disabled users:

  • remove avatar
  • anonymization of the name

Is there any configuration available to do this automaticaly?

The user name can be changed by the ldap: Should be easy. But how can i disable or overwrite the avatar for inactive users?

Regards

Manuel

2 answers

0 votes
Vijay Sv May 9, 2021

Did you find any automated way to delete inactive users' avatar?

0 votes
Danyal Iqbal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2018

taek a backup before attempting this:

There are 4 tables involved here:

  • avatar stored the avatar list
  • propertyentry stored the association between user and the avatar. using "property_key=user.avatar.id" to search for the mapping
  • propertynumber stored the current avatar used
  • external_entities stored the username

A good place to start is the following sql:

SELECT u.lower_user_name,a.*
  FROM app_user as u left join propertyentry as pe 
 on pe.entity_id=u.id
  left join propertynumber as pn on pe.id=pn.id
   left join avatar as a on a.id=pn.propertyvalue
  where 
 entity_name = 'ApplicationUser'  and property_key='user.avatar.id';
Manuel February 22, 2018

Thanks, i will give a try

Suggest an answer

Log in or Sign up to answer