Re: Set Privileges on All Tables (and/or Sequences) at Once

From: John DeSoi <desoi(at)pgedit(dot)com>
To: <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Set Privileges on All Tables (and/or Sequences) at Once
Date: 2005-10-07 17:41:40
Message-ID: 94207745-BFD1-4366-8948-623B716C3FA8@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Oct 7, 2005, at 1:20 PM, <operationsengineer1(at)yahoo(dot)com>
<operationsengineer1(at)yahoo(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Derrick Betts 2005-10-07 17:43:11 Re: Set Privileges on All Tables (and/or Sequences) at Once
Previous Message Sean Davis 2005-10-07 17:28:56 Re: Set Privileges on All Tables (and/or Sequences) at