pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: M. D. <lists@turnkey.bz>
To: senthilnathan <senthilnathan.t@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Read Only Role
Date: Wed, 30 Nov 2011 18:05:48 -0600
Message-ID: <4ED6C4DC.7050904@turnkey.bz> (raw)
In-Reply-To: <1322632334476-5034628.post@n5.nabble.com>
References: <1322632334476-5034628.post@n5.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

view thread (5+ messages)  latest in thread

Message-ID: <4ED6C4DC.7050904@turnkey.bz>
Permalink:  ../4ED6C4DC.7050904@turnkey.bz/
Also on:    postgresql.org/message-id/4ED6C4DC.7050904@turnkey.bz

copy link · copy postgr.es

reply

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: lists@turnkey.bz, senthilnathan.t@gmail.com
  Subject: Re: Read Only Role
  In-Reply-To: <4ED6C4DC.7050904@turnkey.bz>

* 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