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 is published to other applications via API calls. > > In such a standalone database configuration, are there any security implications > or any downsides to creating the application in the public schema? No, that's fine. Just REVOKE CREATE ON SCHEMA public FROM PUBLIC. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
