On Wed, Sep 5, 2012 at 4:50 PM, Brian Wolf
<..hidden..> wrote:
Thanks for the feedback. Can
PostgreSQL can be configured to permit certain limited privileges
from a specific IP address, and only on specific tables? For
example, only SELECT privs on the Parts table for IP address
<whatever>.
Yes and no.
Grants on tables are per role. Access per IP address does filter by role, so you can do it, but it requires thinking through the role assignments, and which IP addresses to allow that role to access which db's in the pg_hba.conf.
Best Wishes,
Chris Travers