Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 99F8519F7A75 for ; Wed, 30 Nov 2011 20:06:13 -0400 (AST) Received: from dime159.dizinc.com ([66.7.216.77]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RVuAB-000466-MW for pgsql-admin@postgresql.org; Thu, 01 Dec 2011 00:06:12 +0000 Received: from [200.32.232.149] (port=53055 helo=[192.168.54.128]) by dime159.dizinc.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.69) (envelope-from ) id 1RVu9v-0003XP-CN; Wed, 30 Nov 2011 19:05:51 -0500 Message-ID: <4ED6C4DC.7050904@turnkey.bz> Date: Wed, 30 Nov 2011 18:05:48 -0600 From: "M. D." User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:8.0) Gecko/20111124 Thunderbird/8.0 MIME-Version: 1.0 To: senthilnathan CC: pgsql-admin@postgresql.org Subject: Re: Read Only Role References: <1322632334476-5034628.post@n5.nabble.com> In-Reply-To: <1322632334476-5034628.post@n5.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - dime159.dizinc.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - turnkey.bz X-Source: X-Source-Args: X-Source-Dir: X-Pg-Spam-Score: 2.5 (++) X-Archive-Number: 201111/164 X-Sequence-Number: 38758 On 11/29/2011 11:52 PM, senthilnathan wrote: > Is there any simple way to define read only roles. Basically that user should > be able to login and be able to do *select* statements alone. It should be > applied for all tables in all schemas in a database. > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5034628.html > Sent from the PostgreSQL - admin mailing list archive at Nabble.com. > Google is your friend: http://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql