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

From Richard Huxton
Subject Re: changing the permission of _lots_ of tables
Date
Msg-id 457FB204.7050104@archonet.com
Whole thread Raw
In response to changing the permission of _lots_ of tables  ("Roderick A. Anderson" <raanders@acm.org>)
Responses Re: changing the permission of _lots_ of tables  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
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.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: TIMESTAMP WITHOUT TIME ZONE
Next
From: DANTE Alexandra
Date:
Subject: Re: PostgreSQL 8.2 : IPO link warning with ICC 9.1.045