X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B75389FA2C7 for ; Wed, 3 May 2006 00:33:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 34226-05 for ; Wed, 3 May 2006 00:33:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound9.internet-mail-service.net. (outbound9.internet-mail-service.net [216.240.47.200]) by postgresql.org (Postfix) with ESMTP id 0C1539FA9BD for ; Wed, 3 May 2006 00:33:03 -0300 (ADT) Received: from idiom.com (idiom.com [216.240.32.1]) by outbound.internet-mail-service.net (Postfix) with ESMTP id 6763D28112B for ; Tue, 2 May 2006 20:33:02 -0700 (PDT) Received: from [192.168.1.109] (adsl-69-107-132-69.dsl.pltn13.pacbell.net [69.107.132.69]) by idiom.com (8.12.11/8.12.11) with ESMTP id k433X1VV014273 for ; Tue, 2 May 2006 20:33:02 -0700 (PDT) (envelope-from bryce1@obviously.com) Message-ID: <44582466.7010303@obviously.com> Date: Tue, 02 May 2006 20:32:54 -0700 From: Bryce Nesbitt User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.13) Gecko/20060411 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: grant select on database demo to user Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/21 X-Sequence-Number: 25052 I find myself with long lists of tables grant select on xx_tax to user; grant select on xx_trip to user; grant select on xx_foo to user; Is there a way to grant to all tables, with a single grant? I know how to do it in mysql, but not postgres. As close as I get it: #grant select on database demo to user ERROR: invalid privilege type SELECT for database -- ---- Visit http://www.obviously.com/