Re: grant user access - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: grant user access
Date
Msg-id 20040718110755.GA31547@wolff.to
Whole thread Raw
In response to Re: grant user access  (mike g <mike@thegodshalls.com>)
List pgsql-general
On Sat, Jul 17, 2004 at 23:35:35 -0500,
  mike g <mike@thegodshalls.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.

pgsql-general by date:

Previous
From: mike g
Date:
Subject: Re: grant user access
Next
From: Clodoaldo Pinto Neto
Date:
Subject: Re: server closed the connection unexpectedly