GitHub user knightmre added a comment to the discussion: cannot delete user 
"Associated data exists, please delete them first"

On superset 4.1.1, remove all roles from the user then use this SQL Query: 

```sql
-- user to be deleted is id XXX
delete from query where user_id=XXX;
delete from logs where user_id=XXX;
delete from tab_state where user_id=XXX;
delete from favstar where user_id=XXX;
delete from key_value where changed_by_fk=XXX;
delete from key_value where created_by_fk=XXX;
delete from logs where user_id=XXX;
delete from ab_user where id=XXX;
```

GitHub link: 
https://github.com/apache/superset/discussions/40137#discussioncomment-16924831

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: 
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to