[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Print labels

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