This is completely subjective. but my favorites are: John Paul
Jones (led zeppelin), Paul McCartney (beatles), Roger Waters (Pink
floyd), Jack Casady (Jefferson Airplane, Hot Tuna), Oliveri from
the old Queens of the stone age was great too.
I think Geezer Butler (Black Sabbath/GZR/Heaven and Hell), Roger
Glover (Deep Purple/solo), Steve Harris (Iron Maiden), Burke Shelly
(Budgie), Jack Bruce (Cream), Duff McKagan (Guns n Roses/Velvet
Revolver/guitar in Loaded), Lemmy (Motorhead) and Phil Lynott (Thin
Lizzy) are great bassists