Re: Using the public schema

2018-04-25 Thread Charlin Barak
Thanks Laurenz. That works. On Tue, Apr 24, 2018 at 4:00 PM, Laurenz Albe wrote: > Charlin Barak wrote: > > > We will be developing three new applications in PostgreSQL, each having > its own > > database instance running on different hosts. We will only have one > schema per > > Postgres inst

Re: Using the public schema

2018-04-24 Thread Laurenz Albe
Charlin Barak wrote: > We will be developing three new applications in PostgreSQL, each having its > own > database instance running on different hosts. We will only have one schema per > Postgres instance. The data is read-write only by one application/schema in > the > DB instance and the data

Re: Using the public schema

2018-04-23 Thread Thomas Poty
Erratum : The main problem with the public schéma is the default privileges (*create*) granted to all users able to connect. Le lun. 23 avr. 2018 à 21:16, Thomas Poty a écrit : > Hi charlin, > I invite you to read this doc it explains very well the security issue > with the public schéma : >

Re: Using the public schema

2018-04-23 Thread Thomas Poty
Hi charlin, I invite you to read this doc it explains very well the security issue with the public schéma : https://wiki.postgresql.org/wiki/A_Guide_to_CVE-2018-1058:_Protect_Your_Search_Path The main problem with the public schéma is the default privileges (execute) granted to all users able to

Using the public schema

2018-04-23 Thread Charlin Barak
Hi, We will be developing three new applications in PostgreSQL, each having its own database instance running on different hosts. We will only have one schema per Postgres instance. The data is read-write only by one application/schema in the DB instance and the data is published to other applicati