Sunday , December 22 2024

Why PostgreSQL Allows Non-Privileged Users To Create Tables?

 

If you grant users the right to connect in a database, they can create a table under the default schema, the public schema.

It was weird when I first heard about it. They will probably limit it in the future. This is still the case in version 10.0.

You must revoke the permission granted to the public scheme as follows.

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *