Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 41B122E43CB for ; Wed, 6 Feb 2008 17:02:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 24958-05-3 for ; Wed, 6 Feb 2008 17:02:25 -0400 (AST) Received: from mtao01.charter.net (mtao01.charter.net [209.225.8.186]) by postgresql.org (Postfix) with ESMTP id B131A2E40D7 for ; Wed, 6 Feb 2008 17:02:24 -0400 (AST) Received: from aarprv04.charter.net ([10.20.200.74]) by mtao01.charter.net (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20080206210202.ITGL23018.mtao01.charter.net@aarprv04.charter.net> for ; Wed, 6 Feb 2008 16:02:02 -0500 Received: from [192.168.1.215] (really [68.186.33.18]) by aarprv04.charter.net with ESMTP id <20080206210202.IWVR17353.aarprv04.charter.net@[192.168.1.215]> for ; Wed, 6 Feb 2008 16:02:02 -0500 From: johnf To: pgsql-sql@postgresql.org Subject: Information schema permissions Date: Wed, 6 Feb 2008 13:01:35 -0800 User-Agent: KMail/1.9.6 (enterprise 20070904.708012) MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200802061301.35718.jfabiani@yolo.com> X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/37 X-Sequence-Number: 30128 Assume a standard install on Linux (what ever that means). Would a normal user have access to information schema? I have a front end written in python that accesses tables and permissions are set based on roles. But I do nothing with respect to the information schema view. I would like my program to access the view. Would there be anything preventing a standard user from 'SELECT' access? -- John Fabiani