How to add User with Read Only Access [INTERNAL]

[Cook, Brian - AIT]

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.

[Igor Romanchenko]

On Thu, Nov 15, 2012 at 7:59 PM, Cook, Brian - AIT <

Post by Cook, Brian - AIT
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