Re: How to add User with Read Only Access [INTERNAL]

From: Igor Romanchenko <igor(dot)a(dot)romanchenko(at)gmail(dot)com>
To: "Cook, Brian - AIT" <Brian(dot)J(dot)Cook(at)transamerica(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: How to add User with Read Only Access [INTERNAL]
Date: 2012-11-15 20:25:56
Message-ID: CAP95GqkNkxetAtkAaj7=HxFFjJTMukoocFtsovqPF2zUf36ckw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Nov 15, 2012 at 7:59 PM, Cook, Brian - AIT <
Brian(dot)J(dot)Cook(at)transamerica(dot)com> wrote:

> I am pretty new to using a PostgreSQL database and have downloaded and
> installed the PgAdmin3 tool to perform administration on a database that
> has been installed with another 3rd party application. With an upgrade
> of this application, we are converting from using an Oracle database to a
> PostgreSQL database. We currently have a group of DBA people that perform
> admin functions on the Oracle databases, but they do not have any knowledge
> of the PostgreSQL database. We currently allow some users read only access
> to the Oracle database for this application and I am looking to find out
> how to add a user with read only access to the PostgreSQL database, using
> the PgAdmin3 tool. I am looking for more of a step by step process to do
> this and I am not finding any type of “How To” information in the
> PostgreSQL documentation.****
>

Here are some instructions to do that.
http://stackoverflow.com/questions/760210/how-do-you-create-a-read-only-user-in-postgresql

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Gavan Schneider 2012-11-18 04:56:56 Re: RESOLUTION: Restoring data from TABLESPACE files
Previous Message Mick 2012-11-15 20:11:56 Re: Query on JSON field type