In the book Beginning WordPress 3 the author advises that changing the default WP table prefixes can provide some slight security advantage (protects from SQL injection scripts). I found several articles that explain how to do this as well. I've also seen people arguing that it's not all that helpful. I thought I would try it on the theory that if it was reasonably doable and even slightly helpful, why not do it?
So, for a new project I did a Fantastico Installation, which meant that I had to go into the actual Tables via PHPmyAdmin, which I did. I changed the 11 standard table names, plus a couple of things in wp_options and in wp_usermeta, and finally the table prefix in the wp-config.php. When done I was able to login to the admin and all seems well.
My question is: can I now go forward and not worry about needing to change anything when I activate new plugins? Is this something that, once done properly, is done? That seems to be the implication but no one explicitly states this, either in the book, or in the articles I've read.
Here's links to 2 articles, for FYI: http://digwp.com/2010/10/change-database-prefix/