On Sat, Dec 24, 2005 at 08:41:49 -0400, robert mena <robert.mena@xxxxxxxxx> wrote: > > If I'd need to define a user with SELECT privileges to all tables in > my test database, how could I do that? You can't. You can write a script that will give them access to all of the tables that currently exist. But if you create new ones, they won't get any access by default to the new tables.
