Re: can't "grant all on database..."

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Travis Hume <travis(dot)hume(at)tenzing(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: can't "grant all on database..."
Date: 2003-06-18 21:49:51
Message-ID: 20030618144529.H40289-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 18 Jun 2003, Travis Hume wrote:

> Ok, I give up.
>
> I've created a database called "Inflight" using user "fc". I want to
> create a second user called "johndoe" and grant him all priviledges on
> the "Inflight" database and then restrict him access to certain
> IPAddress using the pg_hba.conf file.
>
> Anyone know the magic words?

I think you'll need to grant all privs to each of the schemas, tables, etc
the user should have access to. There have been scripts that should do
the tables at least in the archives (I haven't paid enough attention to
know if they deal with other objects).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-18 21:53:44 Re: A creepy story about dates. How to prevent it?
Previous Message Tom Lane 2003-06-18 21:48:44 Re: How indexes are updated