Re: [ADMIN] User based access - Mailing list pgsql-admin

From Gregg Berkholtz
Subject Re: [ADMIN] User based access
Date
Msg-id 3695B93C.DA9F44A5@gbcomputers.com
Whole thread Raw
In response to User based access  (Paul Dwerryhouse <paul@xenu.ee.mu.oz.au>)
Responses RE: [ADMIN] User based access
List pgsql-admin
On this same note, can you restrict a certain user to just read-only and allow
others to have write access to certain tables. If so, how would I go about this?

Thanks

-----------------------------------------------------
/////////////   Gregg Berkholtz - Owner/Consultant
|    G B    |    PC, Novell, and Linux Support/Sales
| Computers |     info: www.gbcomputers.com
\\\\\\\\\\\\\

Paul Dwerryhouse wrote:

> Hi all,
>
> Would I be correct in saying that there is no way to allow a few users to
> have access to a database, but deny others, under Postgresql?
>
> I have scoured the documentation (which draws a blank) and have looked
> through other similar questions to this mailing list (which all seem to
> have gone unanswered).
>
> I'm not having any problems creating users, or using the pg_hba.conf -
> all I want to do is prevent some postgres users from accessing certain
> databases...
>
> Cheers,
>
> Paul.
>
> --
> Paul Dwerryhouse                                        paul@xenu.ee.mu.oz.au
> "The growing use of e-mail, not to mention Web-page publishing, threatens to
> reverse the trend towards illiteracy among the supposedly educated without at
> the same time improving their spelling". -- Michael Swaine, Dr. Dobb's Journal

--




pgsql-admin by date:

Previous
From: "chrisb"
Date:
Subject: COPY gets slower and slower and slower and....
Next
From: "Neil Burrows"
Date:
Subject: RE: [ADMIN] User based access