Postgres Pro
Downloads
Home   >   mailing lists

Re: changing the permission of _lots_ of tables - Mailing list pgsql-general

From A. Kretschmer
Subject Re: changing the permission of _lots_ of tables
Date
Msg-id 20061213081529.GA16687@a-kretschmer.de
Whole thread Raw
In response to Re: changing the permission of _lots_ of tables  (Richard Huxton <dev@archonet.com>)
Responses Re: changing the permission of _lots_ of tables  ("Roderick A. Anderson" <raanders@acm.org>)
List pgsql-general
Tree view 
am  Wed, dem 13.12.2006, um  7:55:48 +0000 mailte Richard Huxton folgendes:
> Roderick A. Anderson wrote:
> >Works great ... up to a point.  I now need to change the users and
> >owners associated with all the tables without changing their permissions.
> >
> >Is there a way or hack to do mass changes like these.
>
> Write a small plpgsql function to take a pattern and set permissions
> based on that. A quick bit of googling should find some examples for you.

Perhaps this one:
http://people.planetpostgresql.org/greg/index.php?/archives/38-Scripting-with-psql.html


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: DANTE Alexandra
Date:
Subject: Re: PostgreSQL 8.2 : IPO link warning with ICC 9.1.045
Next
From: DANTE Alexandra
Date:
Subject: PostgreSQL 8.2 : warnings during the built with ICC 9.1.045