Permission denied for database postgres when creating schemas in dev database

Question

I was able to successfully connect to my app’s dev database, however when I try to create a schema with this script:

client.query(
  `CREATE SCHEMA IF NOT EXISTS ${team};`, (err, res) => {
  if (err) console.log(err.stack);
});

I get the following error:

digitalocean app error: permission denied for database db

I understand that the dev database doesn’t allow me to create databases, but nothing is said about creating schemas which is what I tried to do. It turns out that the default user db doesn’t have that privilege and it seems that there’s no way for me to change it.

What are the default user permissions? Should I be allowed to create PostgreSQL schemas in the dev database? This is what I get, and it looks like the user I have access to has no permissions whatsoever.

Role name	Attributes	Member of
_dodb	Superuser, Replication	{}
db		{}
doadmin	Create role, Create DB, Replication, Bypass RLS	{db}
postgres	Superuser, Create role, Create DB, Replication, Bypass RLS	{}

danieloliveiravas · Answer

Could anyone solve this? @kamaln7 any news? I’m trying to develop a new API, but I cannot create a new schema on my dev database.

ianwalls · Answer

I am also experiencing this issue, and it’s preventing me from moving forward with a project; I’d love to use hosted Postgres instead of maintaining my own, but I need multiple schema to do it.

mateust · Answer

@kamaln7 , would you mind chiming in?

felipecoury · Answer

I am wondering the same thing. Did you ever get a response?

Related

Question

Permission denied for database postgres when creating schemas in dev database

Related