On Tue, Jul 14, 2020 at 8:25 AM David Gasa i Castell <dgasacas7@xxxxxxxxx> wrote:
And my surprise went when I see the connection done while there is no user granted to connect the database...
"""
PostgreSQL grants privileges on some types of objects to PUBLIC by default when the objects are created. No privileges are granted to PUBLIC by default on tables, table columns, sequences, foreign data wrappers, foreign servers, large objects, schemas, or tablespaces. For other types of objects, the default privileges granted to PUBLIC are as follows:
***CONNECT and TEMPORARY (create temporary tables) privileges for databases;*** (emphasis mine)
EXECUTE privilege for functions and procedures; and USAGE privilege for languages and data types (including domains).
"""
David J.
