Postgres Pro
Downloads
Home   >   mailing lists

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

How to add User with Read Only Access [INTERNAL]

From
"Cook, Brian - AIT"
Date:

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.

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

From
Igor Romanchenko
Date:
On Thu, Nov 15, 2012 at 7:59 PM, Cook, Brian - AIT <Brian.J.Cook@transamerica.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.