On Wed, Dec 28, 2016 at 11:49 AM, Rich Shepard <rshep...@appl-ecosys.com> wrote:
> On Tue, 27 Dec 2016, Chris Weekes wrote: > > I was wondering what steps if any need to be taken to ensure that the >> patient and operational data is secure on a machine and or across the >> network. >> > > Chris, > > I'm far from an expert but until more knowledgeable folks respond I'll > offer a couple of quick suggestins. First, in your postgres data/ directory > modify pg_hba.conf. Specifying hostssl and an appropriate authentication > method > will help. Second, partition your users into postgres role specifying what > each role can access and do. > > The postgresql-9.6-US.pdf manual has all the details. > > HTH, > > Rich > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > *Another thing to consider is DO NOT create your tables in the public schema.Instead, create a separate schema, then only grant access to that schema and tablesto users that are authorized to access them.* -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
