On Wed, Sep 5, 2012 at 4:50 PM, Brian Wolf <[email protected]> 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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
