Postgres Pro
Downloads
Home   >   mailing lists

Re: grant select on all tables of a schema - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: grant select on all tables of a schema
Date
Msg-id 20030618032701.GA7805@wolff.to
Whole thread Raw
In response to grant select on all tables of a schema  (Nabil Sayegh <postgresql@e-trolley.de>)
List pgsql-novice
Tree view 
On Wed, Jun 18, 2003 at 01:39:43 +0200,
  Nabil Sayegh <postgresql@e-trolley.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.

pgsql-novice by date:

Previous
From: "Mel Jamero"
Date:
Subject: Re: Commit within a PL/PGSQL procedure
Next
From: Dani Oderbolz
Date:
Subject: Re: grant select on all tables of a schema