From: | Mark Jewiss <Mark(dot)Jewiss(at)knowledge(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Another access control query |
Date: | 1999-10-14 14:49:36 |
Message-ID: | Pine.BSO.4.10.9910141534140.31618-100000@office.knowledge.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
Similar to other questions I've seen posed in the last day or so,
apologies if this exact question has been asked, I don't think it has.
I want to restrict access to a set of databases to connections from a
specfic machine and a specific user.
Lines in my pg_hba.conf file are similar to this:
host db1 serverip netmask password
Effectively what I want to do is have something like:
host db1 username1 serverip netmask password
host db2 username2 serverip netmask password
thereby ensuring that it is not possible for user2 to connect to db1 from
the same machine.
I know I can set up the different db's so that table security only gives
any access to the user I want, but that is fiddly. Being able to do the
above and prevent connections to the database will resolve that issue.
Any ideas?
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
From | Date | Subject | |
---|---|---|---|
Next Message | Ted Florence | 1999-10-14 14:49:52 | Postgres and Filemaker Pro |
Previous Message | Ted Florence | 1999-10-14 14:44:13 | FIlemaker Pro & Postgres |