Re: select any table

I'm just curious how would having the ability to grant privileges to a
schema be a foot gun?

On Tue, Mar 25, 2008 at 2:54 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>
wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Tue, 25 Mar 2008 13:37:37 -0500
> "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> wrote:
>
> > > O.k. :) but that doesn't change my response. You can't do it with a
> > > single command. You can script it.
> > >
> > >
> >
> > It would be a nice enhancement to have a "select any table" privilege
> > or at least "grant insert/update/delete/select on <schema_name>".
>
> Certainly, but it is also a foot gun.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
> - --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> United States PostgreSQL Association: http://www.postgresql.us/
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFH6UptATb/zqfZUUQRAmhQAJ0bzU5LCF0GU4r3SgihoE22xuqedQCdEOcB
> w3Im5SsA8Y1I4NZNcx1XNjc=
> =pOZY
> -----END PGP SIGNATURE-----
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>