Re: newbie : setting access for users in a web enviroment

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: robert mena <robert(dot)mena(at)gmail(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: newbie : setting access for users in a web enviroment
Date: 2005-12-25 15:00:24
Message-ID: 20051225150024.GA11637@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-12-26 16:06:53 Re: Trigger Behavior in Transactions
Previous Message Andy Astor 2005-12-25 04:29:08 Happy Holidays