Обсуждение: Read Only Role

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.

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

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
---------------------------------------------

Its a session variable. It can be reset(Read Write Mode) by the user itself

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Read-Only-Role-tp5034628p5040717.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.