Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.3) with ESMTP id BAA13680 for ; Tue, 4 May 1999 01:57:15 -0400 (EDT) (envelope-from michael.j.davis@tvguide.com) Received: from prevuepo1.prevuenet.com (prevuepo1.uvsg.com [192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id J5RFXXLD; Tue, 4 May 1999 00:56:51 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2232.9) id ; Tue, 4 May 1999 00:59:53 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC145474@lambic.prevuenet.com> From: Michael J Davis To: "'G. Anthony Reina'" , pgsql-sql@postgreSQL.org Subject: RE: [SQL] Granting select on ALL tables at once Date: Tue, 4 May 1999 00:52:43 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain I use the following technique a lot: -- create a file containing a bunch of grant commands \g grant_all.sql select (('GRANT ALL ON ' || relname) || ' TO PUBLIC;') as "-- grant" FROM pg_class WHERE relkind = 'r' and substr(relname,1,3) <> 'pg_' order by relname; -- table and views \g -- execute the file of grant commends \i grant_all.sql -----Original Message----- From: G. Anthony Reina [SMTP:reina@nsi.edu] Sent: Monday, May 03, 1999 6:05 PM To: pgsql-sql@postgreSQL.org Subject: [SQL] Granting select on ALL tables at once Is there a way to grant a select to a user on all tables. So far, I've only been able to do this table by table. Thanks. -Tony