Mastering PostgreSQL 9.6

Adjusting schema-level permissions

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

Before actually taking a look at schema, I want to 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 you can see, Joe is having a bad day and basically 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  --------+------------------+-------+------- ...