From: Marsha Ramsey <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.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.
Thanks...Marsha
---------------------------------
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. http://im.live.com/messenger/im/home/?source=TAGHM_MAY07
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
