Postgres Pro
Downloads
Home   >   mailing lists

Re: Set Privileges on All Tables (and/or Sequences) at Once - Mailing list pgsql-novice

From John DeSoi
Subject Re: Set Privileges on All Tables (and/or Sequences) at Once
Date
Msg-id 94207745-BFD1-4366-8948-623B716C3FA8@pgedit.com
Whole thread Raw
In response to Set Privileges on All Tables (and/or Sequences) at Once  (<operationsengineer1@yahoo.com>)
List pgsql-novice
Tree view 
On Oct 7, 2005, at 1:20 PM, <operationsengineer1@yahoo.com>
<operationsengineer1@yahoo.com> wrote:

> Set Privileges on All Tables (and/or Sequences) at
> Once
>
> Can this be done?  or am i stuck doing this on each
> table and sequence whenever i create a new group?

There are some functions here which can do this for you en masse.

http://pgedit.com/node/20






John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Set Privileges on All Tables (and/or Sequences) at
Next
From: "Derrick Betts"
Date:
Subject: Re: Set Privileges on All Tables (and/or Sequences) at Once