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
> >