Carol Kaye is one of my all time favorite bass players. She has been a studio player in LA since the early 60's. You can hear her on "Good Vibrations" and "California Girls" with the Beach Boys and the "Theme from Shaft" as well as thousands of other songs.
She plays a Fender P bass and is a real Professional.

I also like Allen Spenner who used to play bass for Joe Cocker and the Grease Band and played bass on the original "Jesus Christ Superstar" soundtrack by Andrew Lloyd Webber and Tim Rice. His playing of a fretless P bass on "What's the Buzz" is pretty amazing.