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 21C7F9DCA39 for ; Tue, 28 Feb 2006 13:10:51 -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 64030-08 for ; Tue, 28 Feb 2006 13:10:49 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web54312.mail.yahoo.com (web54312.mail.yahoo.com [206.190.49.122]) by postgresql.org (Postfix) with SMTP id C43AC9DCA1B for ; Tue, 28 Feb 2006 13:10:47 -0400 (AST) Received: (qmail 36376 invoked by uid 60001); 28 Feb 2006 17:10:47 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=w3AijyKZCdAvx36b3Ee1nzZowD3Chn/Juy1i0Jr/9P6NbfcaLrFBs2A2PpqAFJJcBTH9cH15XD53/Z0ylr8mtH7Z/Ex4qu7lidVRxaup8T9WIpJq69dmmxsnr/0dLIc4G63RZQhdPV8YYCKSBFP26sJtDnjBNPGiVUqmK86+Lxc= ; Message-ID: <20060228171047.36374.qmail@web54312.mail.yahoo.com> Received: from [216.184.28.50] by web54312.mail.yahoo.com via HTTP; Tue, 28 Feb 2006 09:10:47 PST Date: Tue, 28 Feb 2006 09:10:47 -0800 (PST) From: chester c young Subject: Re: grant select,... over schema To: Michael James , sql pgsql In-Reply-To: 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.973 required=5 tests=[AWL=-0.385, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 0.973 X-Spam-Level: X-Archive-Number: 200602/325 X-Sequence-Number: 24335 do not want to grant ALL PRIVILEGES to user, only SELECT - do not want PUBLIC to have any dml priveleges on this schema --- Michael James wrote: > GRANT ALL PRIVILEGES ON databaseName To username; > > > 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