Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group