Re: grant user access

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: mike g <mike(at)thegodshalls(dot)com>
Cc: Tom Allison <tallison(at)tacocat(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: grant user access
Date: 2004-07-18 11:07:55
Message-ID: 20040718110755.GA31547@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Jul 17, 2004 at 23:35:35 -0500,
mike g <mike(at)thegodshalls(dot)com> wrote:
> See http://www.postgresql.org/docs/7.4/static/sql-grant.html
>
> Looks like you need something like GRANT ALL SELECT, ... ON DATABASE foo
> To bar;

I don't think this does all of what he wants. That just lets him
create schemas and use the database.
To grant access to the tables, schemas and sequences he needs to write
queries to get the names of those objects and then issue grants to them.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clodoaldo Pinto Neto 2004-07-18 11:18:07 Re: server closed the connection unexpectedly
Previous Message mike g 2004-07-18 04:35:35 Re: grant user access