Aldehyde dehydrogenase (ALDH) is a proposed biomarker and possible target to eradicate cancer stem cells. ALDH inhibition as a treatment approach is supported by anti-cancer effects of the alcohol-abuse drug disulfiram (DSF, Antabuse). Given that metabolic products of DSF, rather than DSF itself inhibit ALDH in vivo, and that DSF's anti-cancer activity is potentiated by copper led us to investigate the relevance of ALDH as the suggested molecular cancer-relevant target of DSF. Here we show that DSF does not directly inhibit ALDH activity in diverse human cell types, while DSF's in vivo metabolite, S-methyl-N,N-diethylthiocarbamate-sulfoxide inhibits ALDH activity yet does not impair cancer cell viability. Our data indicate that the anti-cancer activity of DSF does not involve ALDH inhibition, and rather reflects the impact of DSF's copper-containing metabolite (CuET), that forms spontaneously in vivo and in cell culture media, and kills cells through aggregation of NPL4, a subunit of the p97/VCP segregase. We also show that the CuET-mediated, rather than any ALDH-inhibitory activity of DSF underlies the preferential cytotoxicity of DSF towards BRCA1- and BRCA2-deficient cells. These findings provide evidence clarifying the confusing literature about the anti-cancer mechanism of DSF, a drug currently tested in clinical trials for repositioning in oncology.