Re: Newbie Question, how to grant permissions on all tables in schema/db - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Newbie Question, how to grant permissions on all tables in schema/db
Date
Msg-id 20041109014417.GA71632@winnie.fuhr.org
Whole thread Raw
In response to Newbie Question, how to grant permissions on all tables in schema/db  (Kenji Morishige <kenjim@juniper.net>)
List 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/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: server auto-restarts and ipcs
Next
From: Joel
Date:
Subject: Re: Postresql RFD version 2.0 Help Wanted.