How to disable avatar for inactive users?

Question

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 · Answer

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

Manuel_9gzgju · Answer

Thanks, i will give a try

Danyal Iqbal · Answer

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