On Tue, 27 May 2003, Bruno Wolff III wrote:
> On Mon, May 26, 2003 at 18:29:38 +0200,
> stephane rouille <srouille@infobiogen.fr> wrote:
> > Hi all,
> >
> > I want to give SELECT privilege on all the tables of my db to an other user. I can give select privilege for one
table,then a second... Is it possible to do this in one stage?
>
> There isn't a single SQL command to do it, but it would be easy to write
> a script to do it in for example perl.
Or, as I am planning to do having just come across GRANT USAGE ON SCHEMA... not
allowing me to select from the contained tables, write a plpgsql function, run
it and then drop it.
--
Nigel J. Andrews