Why can't the database owner create schemas and how can I enable that?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Why can't the database owner create schemas and how can I enable that?
Date: 2017-09-23 05:29:46
Message-ID: CAGuHJrOPm_VGXtVZ=+6ZPXDubCnoxJuJ0bUpfztFzjMzFxv+5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am setting up a database for an app. So I create a user without superuser
but with login priveleges

I then create a database and set it's owner to that user like this...

dropdb --if-exists api_development
dropuser --if-exists api_user

createuser api_user -P -d
createdb api_development -O api_user

The app can now connect to the database but it can't create any tables,
schemas or anything else unless I give it superuser privileges.

Is there any way I can make this user a superuser for this database without
making it a superuser on other databases?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vladimir Mihailenco 2017-09-23 06:18:50 shared_buffers smaller than max_wal_size
Previous Message Tom Lane 2017-09-23 03:38:06 Re: Is float8 a reference type?