My situation is that I have a site with several subdomains and I wish for them to share a single user database and also a single permissions database. I understand that this can be done by sharing the same table prefix for users and would appreciate if somebody could shed a bit more light on this for me; will it involve me hunting down all references to the user table and altering them, or is there a simpler solution.

My second question is, would it be possible for all of these sites to run off the same installation? Whilst I would like them all have their own themes and content (which I assume is all stored in the database), I would also find it very helpful if updates and patches could be applied to a single installation as opposed to 6 or 7.