Re: user to database restriction?

That seems like a lot of work. . . and could become easily outdated. No?

How about in pg_hba.conf? There's no way to say only user xyz can connect
to database abc?

I tried something like this in my pg_hba.conf, but now nobody can connect
to it.

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

I was hoping this config would permit user "postgres" to connect to any
database, but limit user "mark" to shopdb.

Maybe I'm missing something, but isn't this a serious security problem for
postgres installations used by many people - like in an ISP environment?

-Jon

On Sun, 10 Feb 2002, Chris Ruprecht wrote:

> Jon,
>
> the only way I can think of doing this is by revoking the user's
> rights to the tables of the databases they have no business in.
>
> I know this is not exactly the answer you're looking for ...
>
> Best regards,
> Chris
>
> At 17:54 -0500 02/10/2002, Jon August wrote:
> >Can I restrict a user to a single database? It seems like any user can
> >connect to any database. . .
> >
> > -Jon
> >