Re: newbie : setting access for users in a web enviroment - Mailing list pgsql-general

On Sat, Dec 24, 2005 at 08:41:49 -0400,
  robert mena <robert.mena@gmail.com> 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.