Обсуждение: grant options

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,
thena second... Is it possible to do this in one stage? 
thank you.
Stéphane Rouillé.

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.

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