GitHub user C-monC added a comment to the discussion: cannot delete user "Associated data exists, please delete them first"
This script has worked for me without problems and I continue to use it. It was written quickly so test it first. The reason for the select is that I use this with a != on the surname. ``` delete from favstar where user_id in (select id from ab_user where email = 'users-email'); delete from key_value where changed_by_fk in (select id from ab_user where email = 'users-email'); delete from key_value where created_by_fk in (select id from ab_user where email = 'users-email'); delete from logs where user_id in (select id from ab_user where email = 'users-email'); delete from ab_user_role where user_id in (select id from ab_user where email = 'users-email'); update ab_user set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update ab_user set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); update tables set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update tables set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); delete from sql_metrics where created_by_fk in (select id from ab_user where email = 'users-email'); update table_columns set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); update table_columns set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update sqlatable_user set user_id=null where user_id in (select id from ab_user where email = 'users-email'); update sl_datasets set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update sl_datasets set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); update sl_columns set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update sl_columns set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); delete from sl_dataset_users where user_id in (select id from ab_user where email = 'users-email'); update dashboards set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update dashboards set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); update slices set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update slices set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); delete from dashboard_user where user_id in (select id from ab_user where email = 'users-email'); delete from slice_user where user_id in (select id from ab_user where email = 'users-email'); update slices set last_saved_by_fk=null where last_saved_by_fk in (select id from ab_user where email = 'users-email'); update sl_tables set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update sl_tables set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); update annotation_layer set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update annotation_layer set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); update tab_state set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update tab_state set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); delete from tab_state where user_id in (select id from ab_user where email = 'users-email'); update dbs set created_by_fk=null where created_by_fk in (select id from ab_user where email = 'users-email'); update dbs set changed_by_fk=null where changed_by_fk in (select id from ab_user where email = 'users-email'); delete from query where user_id in (select id from ab_user where email = 'users-email'); delete from ab_user where id in (select id from ab_user where email = 'users-email'); ``` GitHub link: https://github.com/apache/superset/discussions/40137#discussioncomment-16924813 ---- 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]
