-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 25 Mar 2008 13:37:37 -0500 "Roberts, Jon" <Jon.Roberts@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general