Re: Limiting user privileges - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Limiting user privileges
Date
Msg-id 20050111211839.GC19876@wolff.to
Whole thread Raw
In response to Re: Limiting user privileges  (Tad Marko <tmarko@metrosplash.com>)
Responses Re: Limiting user privileges
List pgsql-admin
On Tue, Jan 11, 2005 at 14:26:15 -0600,
  Tad Marko <tmarko@metrosplash.com> wrote:
>
> I can
>
> GRANT ALL ON a_specific_table TO user
>
> but I can't figure out how to simply give some privilege to a user on
> all tables.

You can't do it with a single GRANT statement. You need to write a script
or function to do it.

pgsql-admin by date:

Previous
From: "BASEI, Sidnei R."
Date:
Subject: PostgreSQL Performance
Next
From: "Lee Wu"
Date:
Subject: Re: Vacuum full - disk space eaten by WAL logfiles