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 BD8A79FA2C3 for ; Sat, 6 May 2006 16:46:29 -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 57164-04 for ; Sat, 6 May 2006 16:46:24 -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 7F7B49F969C for ; Sat, 6 May 2006 16:46:24 -0300 (ADT) Received: from idiom.com (idiom.com [216.240.32.1]) by outbound.internet-mail-service.net (Postfix) with ESMTP id 4CC882A78E8; Sat, 6 May 2006 12:46:22 -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 k46JkLHM098235; Sat, 6 May 2006 12:46:21 -0700 (PDT) (envelope-from bryce1@obviously.com) Message-ID: <445CFD05.5070808@obviously.com> Date: Sat, 06 May 2006 12:46:13 -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: "A. Kretschmer" , pgsql-sql@postgresql.org Subject: Re: grant select on database demo to user References: <44582466.7010303@obviously.com> <20060503050720.GA26223@webserv.wug-glas.de> In-Reply-To: <20060503050720.GA26223@webserv.wug-glas.de> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/71 X-Sequence-Number: 25102 A. Kretschmer wrote: > Is there a way to grant to all tables, with a single grant? I know how > > > No, but you can use a little Script, please read: > http://people.planetpostgresql.org/greg/index.php?/archives/38-guid.html#extended > > HTH, Andreas > Thanks, What always happens is I create a new view, or replace an old view, and the grant step gets forgotten. Then I get angry users who can't see the view (I can see it, just they can't).... -Bryce