Re: changing the permission of _lots_ of tables

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: changing the permission of _lots_ of tables
Date: 2006-12-13 07:55:48
Message-ID: 457FB204.7050104@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DANTE Alexandra 2006-12-13 08:08:18 Re: PostgreSQL 8.2 : IPO link warning with ICC 9.1.045
Previous Message Richard Huxton 2006-12-13 07:53:00 Re: TIMESTAMP WITHOUT TIME ZONE