Re: [ADMIN] User based access

From: Gregg Berkholtz <gregg(at)gbcomputers(dot)com>
To: Paul Dwerryhouse <paul(at)xenu(dot)ee(dot)mu(dot)oz(dot)au>
Cc: pgsql-admin(at)postgreSQL(dot)org
Subject: Re: [ADMIN] User based access
Date: 1999-01-08 07:52:28
Message-ID: 3695B93C.DA9F44A5@gbcomputers.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)xenu(dot)ee(dot)mu(dot)oz(dot)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

--

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Neil Burrows 1999-01-08 09:11:37 RE: [ADMIN] User based access
Previous Message chrisb 1999-01-07 20:01:40 COPY gets slower and slower and slower and....