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


From: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
To: msramsey22(at)yahoo(dot)com, pgsql-admin(at)postgresql(dot)org
Subject: Re: User DB Access - RESTRICTIONS
Date: 2007-05-28 03:53:01
Message-ID: BAY123-F321C0249A913B68A398349A9280@phx.gbl (view raw or whole thread)
Lists: pgsql-admin

>From: Marsha Ramsey <msramsey22(at)yahoo(dot)com>
>To: pgsql-admin(at)postgresql(dot)org
>Subject: [ADMIN] User DB Access - RESTRICTIONS
>Date: Fri, 25 May 2007 07:49:01 -0700 (PDT)
>Hello all,
>How to make a postgres user have access to only one database,

Configure it in pg_hba.conf file with database name and user.

>and to set that access as read only?
Grant Select permission on that DB.

>Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.

Make every IM count. Download Messenger and join the im Initiative now. 
Its free.

In response to

pgsql-admin by date

Next:From: Johann SpiesDate: 2007-05-28 09:11:32
Subject: Syntax in postgresql.conf
Previous:From: Marsha RamseyDate: 2007-05-25 15:28:33
Subject: User DB Access - RESTRICTIONS

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