How to disable avatar for inactive users?

[Manuel]

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

[Vijay Sv]

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

[Danyal Iqbal]

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]

Thanks, i will give a try