Skip site navigation (1) Skip section navigation (2)

Re: Read Only Role

From: "M(dot) D(dot)" <lists(at)turnkey(dot)bz>
To: senthilnathan <senthilnathan(dot)t(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Read Only Role
Date: 2011-12-01 00:05:48
Message-ID: 4ED6C4DC.7050904@turnkey.bz (view raw or flat)
Thread:
Lists: pgsql-admin
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



In response to

Responses

pgsql-admin by date

Next:From: Bèrto ëd SèraDate: 2011-12-01 07:18:10
Subject: Re: transaction error handling
Previous:From: Craig RingerDate: 2011-11-30 23:36:54
Subject: Re: transaction error handling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group