pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
User DB Access - RESTRICTIONS
3+ messages / 2 participants
[nested] [flat]

* User DB Access - RESTRICTIONS
@ 2007-05-25 14:49  Marsha Ramsey <msramsey22@yahoo.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Marsha Ramsey @ 2007-05-25 14:49 UTC (permalink / raw)
  To: pgsql-admin

Hello all,

How to make a postgres user have access to only one database, and to set that access as read only?

Thanks...Marsha


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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* User DB Access - RESTRICTIONS
@ 2007-05-25 15:28  Marsha Ramsey <msramsey22@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Marsha Ramsey @ 2007-05-25 15:28 UTC (permalink / raw)
  To: pgsql-admin


 Hello all,

How to make a postgres user have access to only one database, and to set that access as read only?

Thanks...Marsha

        

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

 
---------------------------------
The fish are biting.
 Get more visitors on your site using Yahoo! Search Marketing.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: User DB Access - RESTRICTIONS
@ 2007-05-28 03:53  Vishal Arora <aroravishal22@hotmail.com>
  parent: Marsha Ramsey <msramsey22@yahoo.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Vishal Arora @ 2007-05-28 03:53 UTC (permalink / raw)
  To: msramsey22@yahoo.com; pgsql-admin




>From: Marsha Ramsey <msramsey22@yahoo.com>
>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 i’m Initiative now. 
It’s free. http://im.live.com/messenger/im/home/?source=TAGHM_MAY07




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-05-28 03:53 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-25 14:49 User DB Access - RESTRICTIONS Marsha Ramsey <msramsey22@yahoo.com>
2007-05-28 03:53 ` Vishal Arora <aroravishal22@hotmail.com>
2007-05-25 15:28 User DB Access - RESTRICTIONS Marsha Ramsey <msramsey22@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox