Re: Limiting user privileges

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tad Marko <tmarko(at)metrosplash(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Limiting user privileges
Date: 2005-01-11 21:18:39
Message-ID: 20050111211839.GC19876@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jan 11, 2005 at 14:26:15 -0600,
Tad Marko <tmarko(at)metrosplash(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bradley Kieser 2005-01-11 21:23:14 Re: Limiting user privileges
Previous Message Lee Wu 2005-01-11 21:11:43 Re: Vacuum full - disk space eaten by WAL logfiles