I created a new database
test and created user 'eonil' with this command:
CREATE ROLE eonil LOGIN ENCRYPTED PASSWORD 'password' NOINHERIT VALID UNTIL 'infinity';
on my PostgreSQL.
psql -U eonil test.
When I tried to make a new schema, it shows an error.
test=> CREATE SCHEMA new_schema AUTHORIZATION eonil; ERROR: permission denied for database test test=>
Why does this make an error? What's required?