Re: user to database restriction? - Mailing list pgsql-admin

From Jon August
Subject Re: user to database restriction?
Date
Msg-id Pine.LNX.4.21.0202102009100.6758-100000@www.internection.com
Whole thread Raw
In response to user to database restriction?  (Jon August <jon@internection.com>)
Responses Re: user to database restriction?
List pgsql-admin
Ok, it looks like the final argument is used to set up realtionships
between remote unix users to pg users.  So wouldn't that mean that
ultimately the user would be able to view any database anyway since
the pg user can view any database?  (aside from revoking privs at the
table level)

Is there any means of user to database access restriction?



On Sun, 10 Feb 2002, Stephan Szabo wrote:

> > local     all                                       password    postgres
> > host      all     xxx.xxx.xxx.xxx  255.255.255.255  password    postgres
> > local     shopdb                                    password        mark
> > host      shopdb  xxx.xxx.xxx.xxx  255.255.255.255  password        mark
>
> The final argument goes to an external file in $PGDATA that lists users
> (and optionally passwords) for the users that are allowed into the db.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: restore whoes
Next
From: Stephan Szabo
Date:
Subject: Re: user to database restriction?