Re: Newbie Question, how to grant permissions on all tables in schema/db

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Kenji Morishige <kenjim(at)juniper(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Newbie Question, how to grant permissions on all tables in schema/db
Date: 2004-11-09 01:44:17
Message-ID: 20041109014417.GA71632@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 08, 2004 at 05:00:49PM -0800, Kenji Morishige wrote:

> I'm wondering what the easy way to grant user/group access on all tables
> in a db.

This comes up from time to time -- search the archives for phrases
like "grant" and "all tables". The responses usually suggest writing
a script or function to query the system catalogs for the list of
tables, views, sequences, etc.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel 2004-11-09 01:59:11 Re: Postresql RFD version 2.0 Help Wanted.
Previous Message Tom Lane 2004-11-09 01:16:15 Re: server auto-restarts and ipcs