Re: grant select on all tables of a schema

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: grant select on all tables of a schema
Date: 2003-06-18 03:27:01
Message-ID: 20030618032701.GA7805@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Jun 18, 2003 at 01:39:43 +0200,
Nabil Sayegh <postgresql(at)e-trolley(dot)de> wrote:
> Hi,
>
> is it possible to 'GRANT <WHATEVER> ON ALL TABLES' in 1 command ?
>
> I'm using 7.3.2

Not unless you write your own function to do it. The GRANT command
only works on one object at a time.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Dani Oderbolz 2003-06-18 08:47:58 Re: grant select on all tables of a schema
Previous Message Mel Jamero 2003-06-18 03:05:52 Re: Commit within a PL/PGSQL procedure