Mastering PostgreSQL 12 - Third Edition

Adjusting schema-level permissions

Once we are done configuring the database level, it makes sense to take a look at the schema level.

Before actually taking a look at the schema, let's run a small test:

test=> CREATE DATABASE test; 
ERROR:  permission denied to create database test=>  
CREATE USER  xy; 
ERROR:  permission denied to create role test=>  
CREATE SCHEMA sales; 
ERROR:  permission denied for database test 

As we can see, Joe is having a bad day and nothing but connecting to the database is allowed.

However, there is a small exception, and it comes as a surprise to many people:

test=> CREATE TABLE t_broken (id int);  
CREATE TABLE 
test=> \d 
          List  of relations 
Schema | Name | Type | Owner --------+----------+--------+------- public | t_broken ...