From: CS DBA <cs_dba@consistentstate.com>
To: M. D. <lists@turnkey.bz>
Cc: senthilnathan <senthilnathan.t@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Read Only Role
Date: Thu, 01 Dec 2011 18:19:57 -0700
Message-ID: <4ED827BD.4090103@consistentstate.com> (raw)
In-Reply-To: <4ED6C4DC.7050904@turnkey.bz>
References: <1322632334476-5034628.post@n5.nabble.com>
<4ED6C4DC.7050904@turnkey.bz>
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
---------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cs_dba@consistentstate.com, lists@turnkey.bz, senthilnathan.t@gmail.com
Subject: Re: Read Only Role
In-Reply-To: <4ED827BD.4090103@consistentstate.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox