Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4E02B2E034F for ; Thu, 13 Dec 2007 01:37:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 29314-01-7 for ; Thu, 13 Dec 2007 01:37:02 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 746272E33C6 for ; Thu, 13 Dec 2007 01:35:44 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lBD5Zg03003213; Thu, 13 Dec 2007 00:35:43 -0500 (EST) To: Paul Lambert cc: pgsql admin Subject: Re: Schema security In-reply-to: <4760905F.2020406@reynolds.com.au> References: <4760905F.2020406@reynolds.com.au> Comments: In-reply-to Paul Lambert message dated "Thu, 13 Dec 2007 10:52:31 +0900" Date: Thu, 13 Dec 2007 00:35:42 -0500 Message-ID: <3212.1197524142@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/81 X-Sequence-Number: 27598 Paul Lambert writes: > I would have thought giving the user all privileges on a schema would by > default add them to all objects within it, Why would you think that? The analogy to think about is that usage privilege on a schema is comparable to read access on a directory. That doesn't necessarily give you access to any single file in the directory --- but lack of it does ensure you cannot get to those files. regards, tom lane