Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3A7D32E3F5A for ; Wed, 6 Feb 2008 19:37:30 -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 29253-10 for ; Wed, 6 Feb 2008 19:37:19 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 3A6C32E3E9B for ; Wed, 6 Feb 2008 19:37:24 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m16NbMGZ020041; Wed, 6 Feb 2008 18:37:22 -0500 (EST) To: johnf cc: pgsql-sql@postgresql.org Subject: Re: Information schema permissions In-reply-to: <200802061301.35718.jfabiani@yolo.com> References: <200802061301.35718.jfabiani@yolo.com> Comments: In-reply-to johnf message dated "Wed, 06 Feb 2008 13:01:35 -0800" Date: Wed, 06 Feb 2008 18:37:22 -0500 Message-ID: <20040.1202341042@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/44 X-Sequence-Number: 30135 johnf writes: > 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? The information schema views are accessible to anyone, but be aware that they show different sets of rows to different people --- you can only see rows that are about tables that you have some access permissions for. This might or might not confuse your app ... regards, tom lane