Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 705A818FE991 for ; Thu, 1 Dec 2011 21:20:18 -0400 (AST) Received: from mail-iy0-f174.google.com ([209.85.210.174]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RWHnU-0000VM-Ft for pgsql-admin@postgresql.org; Fri, 02 Dec 2011 01:20:17 +0000 Received: by iage36 with SMTP id e36so3321065iag.19 for ; Thu, 01 Dec 2011 17:20:03 -0800 (PST) Received: by 10.42.29.1 with SMTP id p1mr11565434icc.40.1322788802093; Thu, 01 Dec 2011 17:20:02 -0800 (PST) Received: from issac.consistentstate.com (c-67-165-192-103.hsd1.co.comcast.net. [67.165.192.103]) by mx.google.com with ESMTPS id r20sm20873663ibz.11.2011.12.01.17.19.58 (version=SSLv3 cipher=OTHER); Thu, 01 Dec 2011 17:19:59 -0800 (PST) Message-ID: <4ED827BD.4090103@consistentstate.com> Date: Thu, 01 Dec 2011 18:19:57 -0700 From: CS DBA User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.2.24) Gecko/20111108 Fedora/3.1.16-1.fc14 Lightning/1.0b2 Thunderbird/3.1.16 MIME-Version: 1.0 To: "M. D." CC: senthilnathan , pgsql-admin@postgresql.org Subject: Re: Read Only Role References: <1322632334476-5034628.post@n5.nabble.com> <4ED6C4DC.7050904@turnkey.bz> In-Reply-To: <4ED6C4DC.7050904@turnkey.bz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.5 (-) X-Archive-Number: 201112/4 X-Sequence-Number: 38762 On 11/30/2011 05:05 PM, M. D. wrote: > > 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 > > > I think you can do this: ALTER USER [user] SET TRANSACTION READ ONLY; -- --------------------------------------------- Kevin Kempter - Constent State A PostgreSQL Professional Services Company www.consistentstate.com ---------------------------------------------