How to delete local media for a specific user ?

[githuberyt]

How to delete local media for a specific user ?

[anoadragon453]

Currently you can only use the admin API to quarantine media by uploader user ID: https://github.com/matrix-org/synapse/blob/develop/docs/admin_api/media_admin_api.md#quarantining-all-media-of-a-user. This prevents your server from serving the media to anyone anymore, and is typically used to combat abusive material (while allowing you to inspect it before blasting it away).

There isn't currently an equivalent endpoint for deleting media by user ID, however you can get all IDs of media uploaded by a given user with the following database query:

SELECT * FROM local_media_repository WHERE user_id = '@alice:example.com';

And then use the Delete Local Media Admin API to remove each one.

[clokep]

however you can get all IDs of media uploaded by a given user with the following database query:

SELECT * FROM local_media_repository WHERE user_id = '@alice:example.com';

There's an admin API for this: https://github.com/matrix-org/synapse/blob/develop/docs/admin_api/user_admin_api.rst#list-media-of-a-user