Re: select any table - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: select any table
Date
Msg-id 20080325115437.4b9dac4b@commandprompt.com
Whole thread Raw
In response to Re: select any table  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
Responses Re: select any table  ("Malinka Rellikwodahs" <aelmalinka@gmail.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 25 Mar 2008 13:37:37 -0500
"Roberts, Jon" <Jon.Roberts@asurion.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-----

pgsql-general by date:

Previous
From: "Edward Blake"
Date:
Subject: Converting mysql "on update" to postgres "rule"
Next
From: Andrew Sullivan
Date:
Subject: Re: Converting mysql "on update" to postgres "rule"