X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E64329DCAAC for ; Tue, 28 Feb 2006 12:35:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59494-03 for ; Tue, 28 Feb 2006 12:35:21 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54308.mail.yahoo.com (web54308.mail.yahoo.com [206.190.49.118]) by postgresql.org (Postfix) with SMTP id EC5A29DCAEE for ; Tue, 28 Feb 2006 12:35:20 -0400 (AST) Received: (qmail 61835 invoked by uid 60001); 28 Feb 2006 16:35:19 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=S9/ump4m3958yDj4NLFcEYbasqRLXbebeqh1VyKJjnI38wODCL3NtHNL5QEsO449e6NiUy46Y0IUC3459qenJphJLgYb/YeTyRRy+13EZfjTBTEbr5KjamKhPX+MEluedsNmiY4ndPm3cnuWZPwIk/Dj7URZlEgNcx11vvXgu8Q= ; Message-ID: <20060228163519.61833.qmail@web54308.mail.yahoo.com> Received: from [216.184.28.50] by web54308.mail.yahoo.com via HTTP; Tue, 28 Feb 2006 08:35:19 PST Date: Tue, 28 Feb 2006 08:35:19 -0800 (PST) From: chester c young Subject: grant select,... over schema To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.919 required=5 tests=[AWL=-0.440, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 0.919 X-Spam-Level: X-Archive-Number: 200602/324 X-Sequence-Number: 24334 is there any way to grant over all applicable objects in a schema, > grant select on schema pop to public; <-- wrong without specifically granting the select on each table? __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com