| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | stephane rouille <srouille(at)infobiogen(dot)fr>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: grant options |
| Date: | 2003-05-27 14:04:28 |
| Message-ID: | Pine.LNX.4.21.0305271503060.3028-100000@ponder.fairway2k.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 27 May 2003, Bruno Wolff III wrote:
> On Mon, May 26, 2003 at 18:29:38 +0200,
> stephane rouille <srouille(at)infobiogen(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincent Hikida | 2003-05-27 14:24:22 | Re: Query Which is not supposted to list NULLS is listing |
| Previous Message | Murthy Kambhampaty | 2003-05-27 13:55:38 | Re: PostgreSQL v7.3.3 Now Available for Download |