On Wed, Aug 17, 2005 at 08:14:02 -0700, Zuoxin.Wang@xxxxxx wrote: > Could you tell us what is the best way to grant a user who can select all > data from all tables, if I don't like to write a script which Andrew > memtioned earlier. Other than some kind of script, you can make them a superuser. That may not work for you though.